Thread: Text to Numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Text to Numbers?
=IF(A10="Y",465,0)


"Michael" wrote:

I need to put a text in one cell, and have it result in a number to another
cell?

Example: cell A10 is Y; equals in cell B10 $465.00
if cell A10 is N; equals in cell B10 $0.00
Reply With QuoteReply With Quote