LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Manicjoe
 
Posts: n/a
Default Applying percentage calculator to table


Hi ............

Grateful of any help to change a table of figures in one currency to
another by
applying a percentage calculator, eg Pounds sterling to US Dollars by
mutiplying
all figures in all cells by 1.73.

I can create the formula to make the change, but can't seem to apply
it to the
figures in the individual cells.

Thanks for any help.

Joe


--
Manicjoe
------------------------------------------------------------------------
Manicjoe's Profile: http://www.excelforum.com/member.php...o&userid=29325
View this thread: http://www.excelforum.com/showthread...hreadid=490422

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 02:30 PM
Income Tax Payable from table with escalating marginal percentage rates. Bosko Excel Worksheet Functions 5 November 4th 05 09:20 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
display data as a percentage of a subtotal in excel pivot table Fl pivot user Excel Discussion (Misc queries) 2 March 26th 05 12:24 PM
How do I manipulate pivot table report to include percentage of? KRUEMJ-Needs some help Excel Discussion (Misc queries) 2 January 31st 05 01:06 AM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"