Nested Excel IF Statement Issues

[TanishaS09]

Hello,

I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance.
=IF(B38<1,0, IF(B38=1,7.2, IF(OR(B38>1,B38<2,(7.2+((B38-1)*4.8)), IF(B38>2,12,FALSE)))))

 

[kweaver]

I suspect it's a paren issue, as well as an AND condition.

Try this:

=IF(B38<1,0, IF(B38=1,7.2, IF(AND(B38>1,B38<2),7.2+(B38-1)*4.8, 12)))

 

[Scott T]

Try

=IF(B38<1,0, IF(B38=1,7.2, IF(AND(B38>1,B38<2),7.2+((B38-1)*4.8), IF(B38>2,12,FALSE))))

 

[TanishaS09]

That's fantastic! It worked! Thanks for taking a look, you just made my day

 

[TanishaS09]

Thanks ScottT, this worked! Thanks for taking a look!

 

[Eric W]

Something like this could work:

=IF(B38<1,0,MIN(12,7.2+(B38-1)*4.8))

or even:

=(B38>=1)*MIN(12,2.4+B38*4.8)