| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a Value based on Results
I'm averaging a list of numbers and want to assign a value based on that
number. For example, the average is 45. I want a cell to display a character based on the average. If the average is between 40 and 49, the value is B. If the average is between 50 and 59, the average is A. Any suggestions? Thanks -- JerryS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assigning class standing based on grade | Excel Discussion (Misc queries) | |||
| assigning value to a column based on a table of values | Excel Discussion (Misc queries) | |||
| =If() results based on cell color? | Excel Worksheet Functions | |||
| Pivot - need to recount based on results | Excel Worksheet Functions | |||
| Graph based on Filtered results | Excel Discussion (Misc queries) | |||
Threaded Mode
