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%?
|