Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Multiply All cells by the same percentage

  1. #1
    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. #2
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035
    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,
    Tom
    ---------------------------
    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
    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
    Norm

Thread Information

Users Browsing this Thread

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

Possible Answers

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

Bookmarks

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