Displaying different currency symbols

[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.

 

[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

 

[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.