Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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%? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find total number of unique model numbers | Excel Worksheet Functions | |||
Formula for average of a top 12 numbers in a column of 24 total nu | Excel Discussion (Misc queries) | |||
I want the total in numbers to show not the formula | Excel Discussion (Misc queries) | |||
total colum using x instesd of numbers what is the formula | Excel Worksheet Functions | |||
Formula to sum total numbers with dashes in them | Excel Discussion (Misc queries) |