Question on how to raise a price 15% in a coloum

C

cindyred

Hello,

I need help on rasisng pricing in a coloum ,(all pricing) I cant figure out
how to do it , I can do it in another colom , but I want to do it in the
coloum that its in .'

any help
Cindyred
 
G

Gary''s Student

In an un-used cell enter:
1.15
copy that cell and paste/special/multiply over the cells you want to increase.
 
P

Pranav Vaidya

try this,

type 0.15 in a different cell.
Copy this cell
Select the column in which your current data is listed
Use Paste Special-->Values and select multiply

HTH,
 
B

Bernard Liengme

Suppose the prices are in range A1:A20
In some empty cell (C1) type 1.15; Copy C1
Select A1:A20; use Edit | Paste Special and specify Multiply
When done, you may delete C1

Of course, the value will not be rounded to two decimals - that is the
beauty of using a second column.
In B1 enter =ROUND(A1*1.15,2); copy down the column
Now select B1:B10, use Copy; select B1 use Edit | Paste Special and specify
Values. Now column B has the prices increased by 15% as values. You can now
delete column A
best wishes
 
C

cindyred

Hello,
thank you ,. I did that , but when I paste special it removes all pricing ,
what I need to do is on Cell F ,. I have 225 prices , is there a simple way
to just raise cell F 15%

Cindy
 
G

Gord Dibben

Enter 1.15 in an unused cell.

Copy that cell.

Select your range of prices and Edit>Paste Special>Multiply>OK>Esc

Clear the cell with 1.15


Gord Dibben MS Excel MVP
 
C

cindyred

Hi and thank you ,

I am"excel stupid" I know how to do it in another cell . but when I paste it
over the turns the other cells 0, aughhhhhhhhh.......
can I email it to someoone ....

Cindy
 
C

cindyred

Hi,

Ok when I do this ,

The first price is $ 9.00 In a new coloum I did 0.15 copy and paste
special in 9.00 colum.I selected Value and multiply. the total came to then
from $ 9.00 to $ 1.35.
when the total should raise to $ 12.60

Cindy
 
P

Peo Sjoblom

Put 1.15 in an empty cell, format this cell the same way as the price cell,
then copy it, now select the cell with $9.00 and do edit>paste special and
select multiply

or use another cell


=A2*115%

and format result the same as A2 (A2 would be the cell withy $9.00)



--


Regards,


Peo Sjoblom
 
C

cindyred

Perfect!!!!!!!!!!!!!!!! Blesssss yu ......... now if I want to do the
following and I will leave you alone ,

15%
20%
25%
30%
40%
50%
cindy
 
P

PaulW

When you copy and past the new answer it will copy the formula, not the
results. When you've used your other cells, copy them as normal, and select
the original values.

This time, right click and select "Paste Special" NOT "Paste" then choose
the "Values" options and press ok.

Otherwise you'll have the *1.15 formula in the old column looking at some
random values.
 
P

PaulW

If you do as suggested the new answer ($1.35) is 15% of the $9.00
As other people have suggested if you use 1.15 instead of 0.15 it will
include the original value, and thus give you an answer of ($10.35)

Also, for reference, $9.00 to $12.60 is an increase of 40%
 
Top