Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lookup formula for currency
On my spread sheet the relevant account currency is entered in column B. Can
other columns be formatted to bear the currency symbol entered in column B.? E.g if A contains USD can G show as USD100.00 when 100.00 is entered and will it still be a numeric value? Also, if I have three rate tables can i have a formula the looks up one of the currency rate tables depending on the country in column A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency Formula | Excel Discussion (Misc queries) | |||
Excel Formula for Currency Depreciation | Excel Discussion (Misc queries) | |||
Currency Conversion Formula | Excel Worksheet Functions | |||
DIFFERENT CURRENCY FORMATS IN FORMULA | Excel Worksheet Functions | |||
Currency Conversion formula | New Users to Excel |