Text to Numbers?

M

Michael

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
 
Top