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

"ferde" wrote:

Is it possible to ask the following

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

Please help

Ferde