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
|