| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complicate function
Hi,
Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
"Sakis" wrote in message
... Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! Try this: =IF(AK880,"excellent",IF(AK860,"very good",IF(AK830,"good","fair"))) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
One way:
=if(ak8<30,"fair",if(ak8<60,"good",if(ak8<80,"Very Good","Excellent"))) Sakis wrote: Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
Thank you for you responce but actually it is not working.....
-- Thank You!!! "Stephen" wrote: "Sakis" wrote in message ... Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! Try this: =IF(AK880,"excellent",IF(AK860,"very good",IF(AK830,"good","fair"))) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
Thank you also but it does not work....
-- Thank You!!! "Dave Peterson" wrote: One way: =if(ak8<30,"fair",if(ak8<60,"good",if(ak8<80,"Very Good","Excellent"))) Sakis wrote: Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
What is it doing? Do you get an error? Do you just get the wrong selection?
Tell us! "Sakis" wrote in message ... Thank you for you responce but actually it is not working..... -- Thank You!!! "Stephen" wrote: "Sakis" wrote in message ... Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! Try this: =IF(AK880,"excellent",IF(AK860,"very good",IF(AK830,"good","fair"))) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
Yes, sorry,
the usual error comes up. The one that usually comes up when there is mistake in any function!! Thanks again -- Thank You!!! "Stephen" wrote: What is it doing? Do you get an error? Do you just get the wrong selection? Tell us! "Sakis" wrote in message ... Thank you for you responce but actually it is not working..... -- Thank You!!! "Stephen" wrote: "Sakis" wrote in message ... Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! Try this: =IF(AK880,"excellent",IF(AK860,"very good",IF(AK830,"good","fair"))) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
What's in ak8?
What did you expect and what did the formula return? If you're not in the USA, you may have to replace the commas (,) with semicolons (;). Sakis wrote: Thank you also but it does not work.... -- Thank You!!! "Dave Peterson" wrote: One way: =if(ak8<30,"fair",if(ak8<60,"good",if(ak8<80,"Very Good","Excellent"))) Sakis wrote: Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
What error is that?
-- Regards, Peo Sjoblom "Sakis" wrote in message ... Yes, sorry, the usual error comes up. The one that usually comes up when there is mistake in any function!! Thanks again -- Thank You!!! "Stephen" wrote: What is it doing? Do you get an error? Do you just get the wrong selection? Tell us! "Sakis" wrote in message ... Thank you for you responce but actually it is not working..... -- Thank You!!! "Stephen" wrote: "Sakis" wrote in message ... Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! Try this: =IF(AK880,"excellent",IF(AK860,"very good",IF(AK830,"good","fair"))) |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicate function
That was I had to change the commas....
Thanks a lot!!!!!! Great support!!! -- Thank You!!! "Dave Peterson" wrote: What's in ak8? What did you expect and what did the formula return? If you're not in the USA, you may have to replace the commas (,) with semicolons (;). Sakis wrote: Thank you also but it does not work.... -- Thank You!!! "Dave Peterson" wrote: One way: =if(ak8<30,"fair",if(ak8<60,"good",if(ak8<80,"Very Good","Excellent"))) Sakis wrote: Hi, Could someone please help me with the below function? IF(AK8<30),"fair", IF(30,001<AK8<60),"good", IF(60,001<AK8<80),"very good", IF(AK880,001),"ecxellent")) I need this to become a function in one cell.... Any idea how can I do this? -- Thank You!!! -- Dave Peterson -- Dave Peterson |
| 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 | |||
Linear Mode
