View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default how do I add 3% or 5 % to a column

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto EditPaste special and select Multiply. you can delete the 1.03 and change
it to 1.05
and do the same thing again for your other range.
HTH
John
"Sue" wrote in message
...
I need to add a percentage to a column for my price list .
Can someone please help me