Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Formula
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 "Ben" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula for Currency Depreciation | Excel Discussion (Misc queries) | |||
Currency Conversion Formula | Excel Worksheet Functions | |||
Currency formula/formatting problem | Excel Discussion (Misc queries) | |||
DIFFERENT CURRENCY FORMATS IN FORMULA | Excel Worksheet Functions | |||
Currency Conversion formula | New Users to Excel |