View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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
...
What formula would I use to gross up a number or total of numbers by 30%?