Posted to microsoft.public.excel.newusers

Graham

external usenet poster

Posts: 155

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Currency Formula	Ben	Excel Discussion (Misc queries)	1	January 25th 08 01:58 AM
Excel Formula for Currency Depreciation	Haleigh Parker-ECON	Excel Discussion (Misc queries)	0	October 9th 07 03:51 AM
Currency Conversion Formula	pantherguy	Excel Worksheet Functions	2	November 22nd 06 09:31 PM
DIFFERENT CURRENCY FORMATS IN FORMULA	BAZZA	Excel Worksheet Functions	3	May 19th 05 12:28 PM
Currency Conversion formula	Mel Garcia via OfficeKB.com	New Users to Excel	2	April 3rd 05 06:53 PM

All times are GMT +1. The time now is 07:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us