Help with a Nested If...

[Steve Swift]

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

Thanks in advance

Steve

 

[mathchick]

=if(h3<4,IF($I$3>1,0,F173*$B$10),0)

 

[Steve Swift]

Many thanks

VERY much appreciated.

Steve

 

[mathchick]

glad to help, thanks for the feedback!