Change Currency symbol dependant upon selected cell value

[Fred]

I'm back on my old favourite again, the wonderful cost estimate
spreadsheet. This time i've been asked to give it an "International
capability".

What this means is I have a table of countries that we might produce
estimates for, containing rates for each country for anual salary rate,
RPI %, Local tax (VAT/Purchase tax), DASD, Tape, Network and Memory
rates. That little lot isn't too much of a problem to incorporate into
the calculations. Where i'm having problems is that the resulting
figures/totals are required to be displayed using the Currency symbol
(also in the table) for the country the estimate is being produced for,
i.e. USA = $, UK = £, Euro Region = € etc. etc. etc ........
currently up to 12 different currencies and liable to grow.

Can anyone me a suggestion/solution as to how to achieve the seemingly
impossible please ?

Thanks and Regards
Fred Newton
Zurich Financial Services

 

[Dave O]

The best I can think of is an if statement used in Totals cells:
=IF(A1=1,TEXT(SUM(D15),"$ 0.00"),IF(A1=2,TEXT(SUM(D15),"€
0.00"),""))

Anyone have a better idea? Anybody? Buehler? Buehler?

 

[Fred]

Thanks Dave, Looks like a fairly straightforward solution.

Regards
Fred

 

[Fred]

This does leave one question unanswered, namely, how to get the
currency symbol to appear on manually entered rate values, such as 10
pencils rate €0.50 or $0.50 or £0.25. etc. The result would display
correctly €5.00, $5.00, £2.50 but not the unit cost field.

Regards
Fred