IF function
Your welcome
"ferde" wrote:
This works GREAT ....
Thank you Mike
"Mike" wrote:
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
|