Remember Me?

#1
February 20th 09, 01:50 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 26
Formula for Grossing up a number or total of numbers

What formula would I use to gross up a number or total of numbers by 30%?

#2
February 20th 09, 02:39 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Formula for Grossing up a number or total of numbers

Assuming the numbers are not the results of formulas...

Enter 1.3 in an empty cell (any empty cell will do)
Copy that cell: EditCopy
Select the range of cells that you want to increase by 30%
Then, EditPaste SpecialMultiplyOK
Delete the 1.3

--
Biff
Microsoft Excel MVP

"Duncan" wrote in message
news
What formula would I use to gross up a number or total of numbers by 30%?

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Brian Excel Worksheet Functions 8 September 19th 08 05:51 AM Sean Excel Discussion (Misc queries) 2 August 17th 07 06:48 PM lavonnejohnson Excel Discussion (Misc queries) 1 May 13th 06 03:54 PM Chopper-One Excel Worksheet Functions 3 March 5th 06 09:57 PM mikeburg Excel Discussion (Misc queries) 3 January 26th 06 11:01 PM

All times are GMT +1. The time now is 03:45 AM.