ExcelBanter - Text to Numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text to Numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/146440-text-numbers.html)

Michael

Text to Numbers?

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

Teethless mama

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

All times are GMT +1. The time now is 12:19 AM.