Displaying different currency symbols

E

Eamon

Does anyone know how to return different currency symbols
in the same cell based on the input rate in another cell?
For example if I input a rate of 1.55 in A1, I want B1 to
format the cell for printing on a form with the $ symbol
and if inputting .7654 to show the ? symbol.
Thanks.
 
F

Frank Kabel

Hi
not really possible with formulas or custom formats. So you'll have to
use VBA (e.g. an event procedure) to achieve this
 
E

Eamon297

Thanks Frank.
Sorry to trouble you further, but would you be able to give me an idea
as to what the VBA should look like?
Thanks again.
Eamon.
 
Top