ExcelBanter - Formula for Grossing up a number or total of numbers

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula for Grossing up a number or total of numbers (https://www.excelbanter.com/new-users-excel/221659-formula-grossing-up-number-total-numbers.html)

Duncan

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

T. Valko

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

All times are GMT +1. The time now is 11:07 PM.