# if range is greater than

#### muizac

##### Board Regular
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

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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

#### muizac

##### Board Regular
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

##### MrExcel MVP
max(range)

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

max(range,70)

or:

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

#### muizac

##### Board Regular

You're a superstar mate.

Andrew

Replies
9
Views
174
Replies
3
Views
91
Replies
7
Views
150
Replies
5
Views
143
Replies
6
Views
751

1,130,051
Messages
5,639,773
Members
417,112
Latest member
PachRedoc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back