Reduce all selected cells by a percentage...

R

Ron Rosenfeld

How do I reduce (or increase) the value of selected cells by a given
percentage?
Click to expand...

Assume your selected cells are A1:A10 and you want to increase them by 6%.

In an unused cell, enter 1.06. Copy that cell.

Then select A1:A10 and Paste/Special Multiply

If A1:A10 contains values, the values will be changed.

If A1:A10 contains formulas, the operation will result in:

(your_formula)*1.06


--ron
 
G

Gord Dibben

To reduce all cells in a range by 10%

Enter .9 in a cell and copy that cell.

Select your range to reduce then Paste Special(in place)>Multuply>OK>Esc.

To increase by 10% enter 1.1 in a cell and as above.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distribution of capital contribution 4
Percentage Increase 11
Calculating percentage growth rate from a cumulative figure 4
Percentage of Weight Loss/Gain 4
formatting a sentence with functions 2
Copy a portion of a Visio diagram 0
percentage in brackets 2
MS Project. Real progress of the project, % complete 1

Top