Greater than less than

[BigB77]

Ok, I hope someone can help here.
IF E1 is greater or less than E2,E3,E4 "individually" bring back value of Q80. if not bring back 0.
I need the same thing for E1,E2,E3,E4
but each would bring back a different value.
I am basically looking to only have a value in H if the value in E is Higher than each other cells in E.

I hope this makes sense.
Thank you,

E F G H

15			Q80
5			Q81
3			Q82
1			Q83

<tbody>
</tbody>

 

[Joe4]

IF E1 is greater or less than E2,E3,E4 "individually" bring back value of Q80. if not bring back 0.

Try:

=IF(OR(E1>MAX(E2:E4),E1< MIN(E2:E4)),"Q80",0)

<min(e2:e4)),"q80",0)[ code]<="" html=""></min(e2:e4)),"q80",0)[>