Hi,
 Is their anyone who can help me in, for me a complicated formel...

I have the following setup

in a5.. the figure 3
in b5..the figure 2
in c5..a letter e.g. D...(D...for Denmark)
in d5..500 (which is an amount)
in f5..0,00
in f6..7,45 (which supposed to exchange rate from DKK to EURO)
in f7..6,36 (supposed to be exchange rate from DKK to USD)
in f8..10,10 (supposed to be exchange rate from DKK to GBP)

I need a formel in box e5, where a5 is pultiplied with b5, multiplied
with d5, using the indicator in box c5 to pickup the exchange rate
in one of the boxes f5 to f8.
I have tried with:  =((a5*b5*d5)*Hvis(C5="E";!F6;0))
but this not right...

The ider is the using the capital letter e.g. D for Danish Kroner, E for
Euro,
U for USD and G for GPB...in that way that the capital letter in box c5
would take the amount from the respective box of f5 to f8...

The currency code in c5 should reflect the amound in d5.

hope anyone can help me

best regards

Bjarne E. Timm