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 |
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 |