Probably very simple, IF/Nesting Statement Problems....

[greentoast]

Hi there, newbie here...

Having a nightmare trying to get a if/nesting statement working. Please help - see what i have so far and let me know where im going wrong.

=IF(D2>1,15,IF(D2>=30,25,IF(D2>=40,35,IF(D2>=50,45))))

Please help, someone, anyone...

Regards

Toast

 

[pgc01]

Hi Toast
Welcome to the board

Try:

=LOOKUP(D2,{1,30,40,50},{15,25,35,45})

 

[Michael M]

Hi Toast and welcome to the Board.
Your formula isn't allowing for aFalse at the the last IF

=IF(D2>1,15,IF(D2>=30,25,IF(D2>=40,35,IF(D2>=50,45))))
Try something like
=IF(D2>1,15,IF(D2>=30,25,IF(D2>=40,35,IF(D2>=50,45,""))))

Which will give you a blank if none of the criteria are met.

Regards
Michael M