View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Is this possible?

=IF(B4="A",12,"whatever you want the answer to be if B4 isn't A")
--
David Biddulph


"jeny04" wrote in message
...
I'm working on an admissions spreadsheet and wanted to know if it is
possible
to convert a letter to a number in a different cell? Like:

Cell B4= A
I want cell B5 to be 12 (A=12)

Is there any function that does such a thing?