IF THEN

[LB]

I'm trying to write an IF then to to test if a cell value is greater than
every value in another range of data (in a column). I tried
=if(A1>Range(A2:A30),1,0) and I also tried =if(A1>A2:A30,1,0) for simple
returns of 1 or 0. No luck. Does anyone have a suggestion?

 

[Teethless mama]

=(A1>MAX(A2:A30))+0

 

[Brad]

=--(a1>max(a2:a30))