Yes, you can use wildcards like that.
The syntax of your formula appears fine.

Could be many reasons for it to result in z
Can you post a sample book?

Could be the values in column E are not really numbers, but "numbers stored as text"
Could be none of the rows meet ALL 3 Criteria