LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The sum and average function view all numbers as zero?? darnocnad Excel Discussion (Misc queries) 3 March 15th 10 04:22 PM
Average of numbers within a range meeting certain criteria opal23k Excel Worksheet Functions 4 August 25th 05 08:51 PM
How do I sort letters before numbers in Excel? RiverGirl Excel Discussion (Misc queries) 4 May 27th 05 04:09 PM
Average of numbers in column between to other numbers Ditandhischeese Excel Discussion (Misc queries) 2 March 31st 05 03:35 AM
average positive numbers Susannah Excel Discussion (Misc queries) 3 February 11th 05 01:47 AM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"