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
|