if range is greater than

[muizac]

Hello,

Quick question - I'm trying to find if *any* cell in range 02 - cf2 is greater than 69.

Would anyone mind expaining what I'm doing wrong with this formula?


=IF(O2:CF2>=70,"yes","no")

Cheers,

Andrew

 

[PaddyD]

if(max(range)>=70,"Y","N")

 

[muizac]

Fantastic. Works great.

Ideally I return a different value for true, showing the highest value in the *any* of the cell range, could you pelase tell me what edit to make to the formula?

ie) The followign would return '90'

a1, 1b, 1c
80, 90, 60

 

[PaddyD]

max(range)

? or, if min you want to show is 70:

max(range,70)

or:

if(max(range)>=70,max(range),"N")

 

[muizac]

Paddy,

You're a superstar mate.

Thanks for your help.

Andrew