IF Function
 

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....

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200903/1

IF Function
 

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

"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:935188b5e3ea8@uwe...
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....

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200903/1

IF Function
 

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

change < to =< to suit

HIH


On 19 Mar, 15:23, "adeel via OfficeKB.com" <u32736@uwe wrote:
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....

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200903/1

IF Function
 

oops, sorry
use Bob's formula
;-)

On 19 Mar, 15:39, Jarek Kujawa wrote:
=IF(A1<50,"Danger Zone",IF(AND(A1=50,A1=<60),"Need Improvement",IF(AND
(A160,A1=<80),"Satisfactory",IF(AND(A180,A1=<100 ),"Good",""))))

change < to =< to suit

HIH

On 19 Mar, 15:23, "adeel via OfficeKB.com" <u32736@uwe wrote:



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....

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200903/1- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

IF Function
 

Hi
Try this
=IF(A1<=50,"Danger Zone",IF(A1<=60,"Need
Improvement",IF(A1<=80,"Satisfactory",IF(A1<=100," Good"))))
HTH
John
"adeel via OfficeKB.com" <u32736@uwe wrote in message news:935188b5e3ea8@uwe...
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....

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200903/1