Currency Formula

[Ben]

I have a workbook where I make quotes in various currencies.
Basically, if I make an offer in Euro's, it should take the price that I
calculated in a cell, then divide it by the rate which I put in and then in
the worksheet, it gives the answer to this formula.

For example:
The price is in cell H37
The rate will then be in cell B29

So, whatever price is in cell H37 needs to be multiplied by B29 which is a
simple =SUM formula, the cell also needs to recognise what currency I am
wanting to convert to, whether it is simply Pounds, Euro or Dollar and put
the respective currency sign in place.

Can anyone make some suggestions for a formula / command to achieve this.

Thanks,
Ben

 

[Fred Smith]

First, you don't need a sum function to multiply two numbers. Use =H37*B29
rather than =sum(H37*b29).

Second, use Vlookup to determine the exchange rate. Set up a table which has
Currency code and Exchange rate. Then use Vlookup to get the proper exchange
rate, and multiply it by your price.

Regards,
Fred