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

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


"cindyred" wrote:

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

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"cindyred" wrote:

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

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cindyred" wrote in message
...
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

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

"Gary''s Student" wrote:

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


"cindyred" wrote:

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

Enter 1.15 in an unused cell.

Copy that cell.

Select your range of prices and EditPaste SpecialMultiplyOKEsc

Clear the cell with 1.15


Gord Dibben MS Excel MVP

On Thu, 15 Nov 2007 07:28:01 -0800, cindyred wrote:

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

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cindyred" wrote in message
...
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

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
"Pranav Vaidya" wrote:

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"cindyred" wrote:

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

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 editpaste 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


"cindyred" wrote in message
...
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
"Pranav Vaidya" wrote:

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"cindyred" wrote:

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

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

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

"Gord Dibben" wrote:

Enter 1.15 in an unused cell.

Copy that cell.

Select your range of prices and EditPaste SpecialMultiplyOKEsc

Clear the cell with 1.15


Gord Dibben MS Excel MVP

On Thu, 15 Nov 2007 07:28:01 -0800, cindyred wrote:

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

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.

"cindyred" wrote:

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cindyred" wrote in message
...
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

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%

"cindyred" wrote:

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