Thread: How can I add a similar amount to a full column of prices
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I add a similar amount to a full column of prices
If not percentage but straight addition of 10p just nter 10 in a cell.

Copy then select the range to change and Paste SpeciaAddOKEsc


Gord Dibben MS Excel MVP

On Wed, 16 Apr 2008 11:01:00 -0700, Colbirds
wrote:

I have a price list with varying percentage profits according to amounts
purchased. I have a set 10p/ltr increase to me and want to make a 10p
increase in every row. How can I get this +10p to repeat down the list

Reply With QuoteReply With Quote