MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add a Percentage in All Cells in a Range

January 30, 2002 - by Juan Pablo Gonzalez

Daniel ask:

Im just trying to find out how I can add 50% to each number in a selected range of numbers. I need each number to have 50% added/ x 1.5.

This one is easy. In an empty cell put 1.5 or 150%, copy it (Control C), then, select the range of numbers you want to increase, go to Edit, Paste Special, Values (or formulas, up to you), and also choose Multiply. Click [OK] and DONE!

That easy!