# 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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,507
Messages
5,837,751
Members
430,515
Latest member
K_Lynch

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