IF Statement

[tennisbuck12]

Team,

How would i rewrite this formula so the middle part is greater 6 and less then 18. I bolded it.

=IF(ISERROR(B9+1),100,(IF(B9<=6,(6-B9)/6*50+100,IF(B9<=18,IF((18-B9)/12*50+50,B9>18,0)))))

 

[tennisbuck12]

Re: IF Statement (Should be easy, just not for me)

I see the issue:

We already accounted for less then 18 in our AND clause, so you don't need another IF for it.
You should just be able to use:

=IF(B9="",100,IF(B9<6,(6-B9)/6*50+100,IF(AND(B9>=6,B9<=18),[COLOR=#333333](18-B9)/12*50+50[/COLOR],0)))

Thanks Joe4. One last question the first part of the formula IF(B9="",100) is actually for is for an error not null. I apologize for mistating that above. How can I change your formula?

 

[Joe4]

Re: IF Statement (Should be easy, just not for me)

Try:

=IF(ISERROR(B9),100,IF(B9<6,(6-B9)/6*50+100,IF(AND(B9>=6,B9<=18),[COLOR=#333333](18-B9)/12*50+50[/COLOR],0)))

 

[tennisbuck12]

Re: IF Statement (Should be easy, just not for me)

Try:

=IF(ISERROR(B9),100,IF(B9<6,(6-B9)/6*50+100,IF(AND(B9>=6,B9<=18),[COLOR=#333333](18-B9)/12*50+50[/COLOR],0)))

I owe you a beer! Thanks again

 

[Joe4]

Re: IF Statement (Should be easy, just not for me)

You are welcome!