IF function

ferde · Apr 4, 2007

Is it possible to ask the following

=if(B2>=300 and <=349,"excellent",if(B2>=500 and <=550,"fair"))

Please help

Ferde

Mike · Apr 4, 2007

Try this
=IF(AND(B2>=300,B2<=349),"Excellent",IF(AND(B2>=500,B2<=550),"Fair","Unknown"))

ferde · Apr 4, 2007

This works GREAT ....
Thank you Mike

Mike said:
Try this
=IF(AND(B2>=300,B2<=349),"Excellent",IF(AND(B2>=500,B2<=550),"Fair","Unknown"))

Mike · Apr 4, 2007

Your welcome

ferde said:
This works GREAT ....
Thank you Mike