| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I really need help with a rule
I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8 ________________ John 3 3 2 3 2 2 3 3 Mark 1 1 1 1 1 1 1 1 Mary 2 2 2 2 3 2 3 2 Sara 0 0 0 0 0 0 0 0 Kate 3 3 2 2 2 3 2 3 At the end of each row I would like a formula that calculates the following: *If someone got mainly 3's then the cell should say "HiPo" (High Potential) *If someone got mainly 2's then the cell should say "HiVa" (High Value) *If someone got mainly 1's then the cell should say "DR" (DEvelopment Required) *If someone got mainly 0's then the cell sould say "NiR" (New in Role) Thankyou for your help on this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If/Then Rule | Excel Discussion (Misc queries) | |||
| Validation Rule | New Users to Excel | |||
| 7 Function rule | Excel Worksheet Functions | |||
| Validation rule | Excel Discussion (Misc queries) | |||
| validation rule | Excel Worksheet Functions | |||
Threaded Mode
