Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IIF functions
Hi,
I am working on an Office 2003 worksheet which determines a grade for users. Grades are based on scores and are graded as shown below. GD1 GD2 GD3 GD4 GD5 96.2 and above 89.3 and above 84.2 to 89.2 78.1 to 84.1 78.0 and below I have a total score for each person i.e. 86.8 which would put this person into GD3 Is an IIF function the best method here? if so how would I code this? Please help if possible. Kind Regards John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IIF functions
Hi John
You can do this easily with a LOOKUP such as: =LOOKUP(A1,{0,"GD5";78.1,"GD4";84.2,"GD3";89.3,"GD 2";96.2,"GD1"}) where A1 holds the value you want to ascribe a grade to. Hope this helps! Richard On 11 Feb, 18:16, "John" wrote: Hi, I am working on an Office 2003 worksheet which determines a grade for users. Grades are based on scores and are graded as shown below. GD1 GD2 GD3 GD4 GD5 96.2 and above 89.3 and above 84.2 to 89.2 78.1 to 84.1 78.0 and below I have a total score for each person i.e. 86.8 which would put this person into GD3 Is an IIF function the best method here? if so how would I code this? Please help if possible. Kind Regards John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IIF functions
With scores entered in A1, try this:
=LOOKUP(A1,{0,78.1,84.2,89.3,96.2;"GD5","GD4","GD3 ","GD2","GD1"}) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "John" wrote in message ... Hi, I am working on an Office 2003 worksheet which determines a grade for users. Grades are based on scores and are graded as shown below. GD1 GD2 GD3 GD4 GD5 96.2 and above 89.3 and above 84.2 to 89.2 78.1 to 84.1 78.0 and below I have a total score for each person i.e. 86.8 which would put this person into GD3 Is an IIF function the best method here? if so how would I code this? Please help if possible. Kind Regards John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IIF functions
=LOOKUP(A1,{0,78.1,84.2,89.3,96.2},{"GD5","GD4","G D3","GD2","GD1"})
"John" wrote: Hi, I am working on an Office 2003 worksheet which determines a grade for users. Grades are based on scores and are graded as shown below. GD1 GD2 GD3 GD4 GD5 96.2 and above 89.3 and above 84.2 to 89.2 78.1 to 84.1 78.0 and below I have a total score for each person i.e. 86.8 which would put this person into GD3 Is an IIF function the best method here? if so how would I code this? Please help if possible. Kind Regards John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Functions In One Column | Excel Worksheet Functions | |||
How do I use multiple functions? | Excel Worksheet Functions | |||
Multiple Functions | Excel Worksheet Functions | |||
Using functions to calculate multiple scores according to their level of difficulty | Excel Worksheet Functions | |||
Multiple functions in one cell | Excel Worksheet Functions |