Thread: How do I subtract 20% from a column of prices?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I subtract 20% from a column of prices?
Assuming the prices are in column A

In B1 enter =A1*.8

Double-click on the fill handle of B1 to copy down.




On Sat, 8 Dec 2007 19:18:00 -0800, mlhank
wrote:

I am trying to line up different prices with percentages taken out for
discounts. I would like to list these side by side in different columns. How
would I tell the rows to subtract 20% off of the price and list it in the
column next to it?

Reply With QuoteReply With Quote