View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
metiz
 
Posts: n/a
Default displaying letters as average instead of numbers


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: http://www.excelforum.com/member.php...o&userid=33769
View this thread: http://www.excelforum.com/showthread...hreadid=535425