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=2Ee. USA =3D $, UK =3D =A3, Euro Region =3D =80 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

The best I can think of is an if statement used in Totals cells:
=3DIF(A1=3D1,TEXT(SUM(D1:D5),"$ 0.00"),IF(A1=3D2,TEXT(SUM(D1:D5),"=80
0=2E00"),""))

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

Thanks Dave, Looks like a fairly straightforward solution.

Regards
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 =800.50 or $0.50 or =A30.25. etc. The result would display
correctly =805.00, $5.00, =A32.50 but not the unit cost field.

Regards
Fred