Currency Formula

B

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula for currency or Macro help. 0
fomula which returns the amount depending on the currency code 3
Simple multiplication of 2 cells = wrong product 8
Assistance with Formula 3
Converting amount($) of my expenditure into the base currency i wa 1
Return value from column 2
IF Formula Error 7
get currency format from souce cell(s) of a formula or referance 4

Top