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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a Value based on Results
What if it is neither average...what should be returned?
Possibly one way: =IF(AND(AVERAGE(A1:A10)=40,AVERAGE(A1:A10)<=49)," B",IF(AND(AVERAGE(A1:A10)=50,AVERAGE(A1:A10)<=59) ,"A","Value if neither average")) HTH, Paul "JerryS" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a Value based on Results
What if it is neither average...what should be returned?
Possibly one way: =IF(AND(AVERAGE(A1:A10)=40,AVERAGE(A1:A10)<=49)," B",IF(AND(AVERAGE(A1:A10)=50,AVERAGE(A1:A10)<=59) ,"A","Value if neither average")) You have a "dead spot" in your range... you will report and out of range message for an average greater than 49 and less than 50. This might be one way to repair that... =IF(AVERAGE(A1:A10)<40,"Out of Range",IF(AVERAGE(A1:A10)<50,"B",IF(AVERAGE(A1:A10 )<60,"A","Out of Range"))) Rick |
Reply |
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) |