# Help with a Nested If...

#### Steve Swift

##### Board Regular
Hi all,

I wonder if one of you may be able to help me with a problem I am struggling with. I have this IF formula

=IF(\$I\$3>1,0,F173*\$B\$10)

If the value in cell I3 is 1 or greater then display zero otherwise F173*B10

What I need to do is this

If the value of cell \$H\$3 is 4 or greater then '0' otherwise =IF(\$I\$3>1,0,F173*\$B\$10)

so that if cell H3 contains 3 or less the result will be =IF(\$I\$3>1,0,F173*\$B\$10)
and if cell H3 contains 4 the result will be 0

Hope that makes sense and that someone can help as its driving me nuts

Steve

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
=if(h3<4,IF(\$I\$3>1,0,F173*\$B\$10),0)

Many thanks

VERY much appreciated.

Steve

glad to help, thanks for the feedback!

Replies
3
Views
177
Replies
9
Views
253
Replies
8
Views
396
Replies
3
Views
95
Replies
7
Views
137

1,203,483
Messages
6,055,665
Members
444,806
Latest member
tofanexcel

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