How to multiply all numbers in Excel?

Question

I have a price list in excel, and I need to change all the values to add 10 percent seeing as there has been a 10% price increase. How can I make it so Excel will automatically change all the prices to add the extra 10%?

Answer 1

if you're first price is in A1

then in B1 type

=A1*1.10

that will increase it 10%. Now just copy/paste the formula all the way down.

tip:

use the "round" function to round off your answer to 2 decimals

=ROUND(A1*1.10, 2)

this will round off A1*1.10 to 2 decimals.

also if you want to play around with see what the effect of different price increases would be, rather than hardcoding the increase into the formula, put the increase in a seperate cell and just reference the cell in your formula.  For example in C1 type 1.10

then change your formula to be

=ROUND(A1*$C$1, 2)

now you can change C1 to be 1.05 (5% increase) and excel will recalc everything for you.

(note the $ in the formula around C1.  This just tells excel to "lock" the cell reference and not change it as you copy/paste it down the list)

Answer 2

Modify the past special answer above.

Copy 1.10 for 10% increase

Copy 1.15 for 15% increase

Copy 0.90 for a 10 % discount

Copy 0.85 for a 15% discount

Use this pattern for other possibilities

Answer 3

Use Paste Special to do this.

In a blank cell, enter either .10 or 10%

Copy the cell.

Highlight all the cells you want to change, right click, and select Paste Special

In the "Operations" section, Select Multiply, and click OK

Problem Solved!

Edit...

To Add them, you will need to copy the numbers first. Then do the above to one column, then copy one of the columns, and use Paste Special again, only select Add this time.