Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Multiply All cells by the same percentage

1. I agreed to these rules
Join Date
23rd May 2003
Posts
13

## Multiply All cells by the same percentage

I would like to take a spreadsheet and to multiply the contents of every cell that has a numeric value (including totals) by 110%. Is there a simple way to do this?

Excel Video Tutorials / Excel Dashboards Reports

2. You should be able to put 1.1 or 110% in a cell, COPY this cell, and then select the full range of cells you want to "inflate" and do a PASTE SPECIAL > check the MULTIPLY check box.

3. Member
Join Date
26th August 2004
Location
Chicago
Posts
21
Try this:

1. In any blank cell (assume A1), type 1.1 (110%).
2. Right below (assume A2), type =\$A\$1 (make sure it is an absolute reference).
3. Copy cell A2 (which contains formula = \$A\$1).
4. Select Edit - Go To - Special.
5. Select "Constants". This will highlight all the selections under "Formulas". Select just "Numbers". Press OK. All your numeric values should now be highlighted.
6. Select PasteSpecial - Formulas - Multiply. Press OK.

All numeric values should now be proceeded by "*\$A\$1". You may have a circular reference in cell A1, because you are multiplying 1.1*\$A\$1. Just erase the "*\$A\$1" to eliminate the circular reference. Be careful for any cells that have dates, because they are also considered numeric values.

Note that by default your total values should have also increased by 10%.
Hope this helps.

Norm

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno