View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Question on how to raise a price 15% in a coloum

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