Adding 10% to a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, this is probably very basic to you guys but after 2 days still can't
find how... OK here is my problem i have a price list from my supplier wich i
have put in excel but i want to add 10% to all the prices of my supplier
without doing it cell by cell for exemple i've got a price tag of $1029 now
what i want to do is ($1029*10%)+$1029=$1131.90

Any help would be appreciated since i got thousands of numbers to calculate
:((
 
In an empty cell, enter the number 1.1
Edit>Copy
Select all your prices, Edit>Paste Special, check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
One way:

You can put 1.1 in a cell, copy it, select your prices, then choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.

However, that may leave you with fractional cents (e.g., 1029.25 * 1.1 =
1132.175 instead of 1132.18.

As an alternative, assuming that your prices are in column A, put this
in an empty column (say, J):

J1: =ROUND(A1*1.1,2)

and copy down as far as needed. Then select column J, copy it, select
column A, and choose Edit/Paste Special, selecting the Values radio
button.
 
Back
Top