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/146439-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 $465.00
if cell A10 is N; equals $0.00

All times are GMT +1. The time now is 03:43 PM.