View Single Post
  #2   Report Post  
Old February 10th 10, 07:18 PM posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
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