Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Multiply All cells by the same percentage

  1. #1
    Join Date
    23rd May 2003
    Registered Users

    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. #2
    Join Date
    22nd April 2003
    Virginia, USA
    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.
    Best Regards,
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

  3. #3
    Join Date
    26th August 2004
    Registered Users
    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.


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Multiply 1 Of 2 Cells Based On Value Of Another
    By dp2 in forum Excel General
    Replies: 2
    Last Post: April 27th, 2008, 11:20
  2. Multiply Cell By Other Cells
    By Table10sHotShot in forum Excel General
    Replies: 2
    Last Post: November 27th, 2006, 03:56
  3. Conditional formula to multiply cells
    By spiritt in forum Excel General
    Replies: 1
    Last Post: July 23rd, 2006, 02:06
  4. Multiply selection by percentage
    By jeepin81 in forum Excel General
    Replies: 6
    Last Post: June 14th, 2006, 15:45
  5. [Solved] TO MULTIPLY ALL CELLS *1
    By sal21 in forum Excel General
    Replies: 9
    Last Post: November 27th, 2003, 22:17


Posting Permissions

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