View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BritArchr BritArchr is offline
external usenet poster
 
Posts: 1
Default 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