| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
