Assigning a Value based on Results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JerryS - 15 Jun 2007 16:01 GMT

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

Signature

JerryS

Reply to this Message

PCLIVE - 15 Jun 2007 16:15 GMT

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

> 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
[quoted text clipped - 3 lines]
> the average is between 50 and 59, the average is A. Any suggestions?
> Thanks

Reply to this Message

Rick Rothstein (MVP - VB) - 15 Jun 2007 16:47 GMT

> 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 to this Message