IF Function

[adeel via OfficeKB.com]

in Cell A1 there would be numeric values from 10 to 100. in Cell A4 I want to
apply following conditions

1. If value in Cell A1 is less then 50, it returns "Danger Zone".
2. If value in Cell A1 is between 50 to 60, it returns "Need Improvement".
3. If value in Cell A1 is 60 to 80, it returns "Satisfactory".
4. If value in Cell A1 is 80 to 100, it returns "Good".

May be it would work with IF Function. but i dont know how.....please some
one help....

 

[Bob Umlas]

=IF(A1<50,"Danger Zone",IF(A1<60,"Need
Improvement",IF(A1<80,"Satisfactory","Good")))

 

[Jarek Kujawa]

=IF(A1<50,"Danger Zone",IF(AND(A1>=50,A1=<60),"Need Improvement",IF(AND
(A1>60,A1=<80),"Satisfactory",IF(AND(A1>80,A1=<100),"Good",""))))

change < to =< to suit

HIH

 

[Jarek Kujawa]

oops, sorry
use Bob's formula
;-)

=IF(A1<50,"Danger Zone",IF(AND(A1>=50,A1=<60),"Need Improvement",IF(AND
(A1>60,A1=<80),"Satisfactory",IF(AND(A1>80,A1=<100),"Good",""))))

change < to =< to suit

HIH





- Poka¿ cytowany tekst -

 

[John]

Hi
Try this
=IF(A1<=50,"Danger Zone",IF(A1<=60,"Need
Improvement",IF(A1<=80,"Satisfactory",IF(A1<=100,"Good"))))
HTH
John