software

Hi everyone

I'm having trouble with a small project I'm working on at school. I
have to calculate the average of a couple of numbers in excel but i
wan't to return the answers in letters.

there are 5 possibilities

A=10
B=8
C=6
D=4
E=2

I want to be able to input the letters A through E
and then get an average in letters and numbers. something like this

a b b c e=6.8 =B
b c e e a=5.6 =D

is this possible?

thanks in advance--
metiz
------------------------------------------------------------------------
metiz's Profile: www.excelforum.com/member.php...oamp;userid=33769
View this thread: www.excelforum.com/showthread...hreadid=535425OK, let's say you input your five values in cells A1-A5, then have your
average in A6. In A7, put this formula:

IF(A6gt;10,quot;Aquot;,IF(A6gt;8,quot;Bquot;,IF(A6gt;6,quot;Cquot;,IF(A6gt;4,quot;Dquot;,( A6gt;2,quot;Equot;)))))

I might be a little off with the parentheses, if I am, sorry, but this
should work. This formula returns FALSE if the value in A6 is less than 2,
if you wanted it to return something else, just put a comma after quot;Equot; and
type in what you want.

If you want the equals sign with your final answer, you can do that with the
concatenate function:
=CONCATENATE(quot;=quot;,(put the above formula here without parentheses))

Hope that helps!
Jezzica85

quot;metizquot; wrote:

gt;
gt; Hi everyone
gt;
gt; I'm having trouble with a small project I'm working on at school. I
gt; have to calculate the average of a couple of numbers in excel but i
gt; wan't to return the answers in letters.
gt;
gt; there are 5 possibilities
gt;
gt; A=10
gt; B=8
gt; C=6
gt; D=4
gt; E=2
gt;
gt; I want to be able to input the letters A through E
gt; and then get an average in letters and numbers. something like this
gt;
gt; a b b c e=6.8 =B
gt; b c e e a=5.6 =D
gt;
gt; is this possible?
gt;
gt; thanks in advance
gt;
gt;
gt; --
gt; metiz
gt; ------------------------------------------------------------------------
gt; metiz's Profile: www.excelforum.com/member.php...oamp;userid=33769
gt; View this thread: www.excelforum.com/showthread...hreadid=535425
gt;
gt;

Your data is ambiguous, you have 6.8 going up to B, but 5.6 going down to D.
Assuming up

=VLOOKUP(A21,{0,quot;Equot;;2.1,quot;Dquot;;4.1,quot;Cquot;;6.1,quot;Bquot;;8.1,quot;A quot;},2,TRUE)

where A21 holds the average.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;metizquot; gt; wrote in
message ...
gt;
gt; Hi everyone
gt;
gt; I'm having trouble with a small project I'm working on at school. I
gt; have to calculate the average of a couple of numbers in excel but i
gt; wan't to return the answers in letters.
gt;
gt; there are 5 possibilities
gt;
gt; A=10
gt; B=8
gt; C=6
gt; D=4
gt; E=2
gt;
gt; I want to be able to input the letters A through E
gt; and then get an average in letters and numbers. something like this
gt;
gt; a b b c e=6.8 =B
gt; b c e e a=5.6 =D
gt;
gt; is this possible?
gt;
gt; thanks in advance
gt;
gt;
gt; --
gt; metiz
gt; ------------------------------------------------------------------------
gt; metiz's Profile:
www.excelforum.com/member.php...oamp;userid=33769
gt; View this thread: www.excelforum.com/showthread...hreadid=535425
gt;