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