View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do I add 3% or 5 % to a column

Put 1.03 (or 1.05) in an empty cell.
Edit|copy that cell
Select the range to adjust.
edit|paste special|choose multiply and values

Clean up that cell with 1.03/1.05 in it.

Sue wrote:

I need to add a percentage to a column for my price list .
Can someone please help me


--

Dave Peterson