Featured Product

Excel Daily News

Search MrExcel

percentage increase

How can you increase the value of a colum of numbers by a certian percentage.

Posted by Rick M on January 27, 2001 2:45 PM

One quick way - is to paste a formula in the column next to the column that has the value you want to increase.If the column with the existing value is in A, then in column B use the formula =A1*1.1 this will return cell A1 plus 10%.then you could copy and paste special (values only)over column A.Hope this helps....

Posted by Mark W. on January 27, 2001 3:31 PM

No need to enter a formula into B1 as Rick M suggests... just enter 1.1, then do a Copy Paste Special... Values and choose the Multiply operation.

(12 responses) HI! I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pu

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View our Privacy Policy, Cookies Policy, and Terms of Use.