how do I set letters to indicate a range of values in one cell
 

I would like info on how to create a formula where you can use a range of
letters to indicate varying values that Excel will recognise. These values
have to be written in one cell so that Excel can determine the value.
For example, A=12, B=10, C=7.5.

So that all I have to do is Put A, B, or C in the cell and Excell will
convert it to the correct value.

I hope that I have made what I wish to do clear enough, and I hope that
someone can help me.

Thanks in anticipation

how do I set letters to indicate a range of values in one cell
 

Without code you will not be able to get the same cell to change to a
number, except possibly by setting up all the letter/value combinations in
autocorrect under the tools menu, but that may get annoying!

If you can use another column, set up a table with your letters and values,
say in A1:B15 on another sheet, say Sheet2

Then on sheet1 in a1 enter

=VLOOKUP(B1,Sheet2!$A$1:$B$15,2,FALSE)

Then in B1 on sheet1 enter one of the letters in A1:A15 on sheet2 and the
corresponding value will appear in A1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"BritArchr" wrote in message
...
I would like info on how to create a formula where you can use a range of
letters to indicate varying values that Excel will recognise. These values
have to be written in one cell so that Excel can determine the value.
For example, A=12, B=10, C=7.5.

So that all I have to do is Put A, B, or C in the cell and Excell will
convert it to the correct value.

I hope that I have made what I wish to do clear enough, and I hope that
someone can help me.

Thanks in anticipation