| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy contents to cell based on value in second cell
I have 5 ranking for evaulations: "Failed", "Poor", "Satisfactory", "Good",
and "Excellent". Depedning on the results of a calculation, I want to have the ranking displayed in a cell. Example: Ranking of 1-50 = Failed Ranking of 51-65 = Poor Ranking of 66-75 = Satisfactory Ranking of 76-90 = Good Ranking 90 = Excellent. How do I do this in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy contents to cell based on value in second cell
One way:
=LOOKUP(A1,{0,"Failed"; 50.1,"Poor"; 65.1,"Satisfactory"; 75.1,"Good"; 90.1,"Excellent"}) In article , Mike Carpenter <Mike wrote: I have 5 ranking for evaulations: "Failed", "Poor", "Satisfactory", "Good", and "Excellent". Depedning on the results of a calculation, I want to have the ranking displayed in a cell. Example: Ranking of 1-50 = Failed Ranking of 51-65 = Poor Ranking of 66-75 = Satisfactory Ranking of 76-90 = Good Ranking 90 = Excellent. How do I do this in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy contents to cell based on value in second cell
Tried that, no matter was in cell, result was "Excellent"...
"JE McGimpsey" wrote: One way: =LOOKUP(A1,{0,"Failed"; 50.1,"Poor"; 65.1,"Satisfactory"; 75.1,"Good"; 90.1,"Excellent"}) In article , Mike Carpenter <Mike wrote: I have 5 ranking for evaulations: "Failed", "Poor", "Satisfactory", "Good", and "Excellent". Depedning on the results of a calculation, I want to have the ranking displayed in a cell. Example: Ranking of 1-50 = Failed Ranking of 51-65 = Poor Ranking of 66-75 = Satisfactory Ranking of 76-90 = Good Ranking 90 = Excellent. How do I do this in Excel? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy contents to cell based on value in second cell
Do you have your calculations set to automatic
(Tools/Options/Calculation)? Works fine here... In article , Mike Carpenter wrote: Tried that, no matter was in cell, result was "Excellent"... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
| Reference Data Range based on cell contents | Charts and Charting in Excel | |||
| how to copy cell contents from one workseet to another worksheet? | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
Linear Mode
