Assigning a Value based on Results

J

JerryS

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
 
P

PCLIVE

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
 
R

Rick Rothstein \(MVP - VB\)

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"))
Click to expand...

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
 
Top