How do I subtract 20% from a column of prices?
 

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?

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?

How do I subtract 20% from a column of prices?
 

With Prices in A2:A100

Try this:

B1: (a discount percent.....eg 20%)

This formula returns the Col_A Price less B1 (20%)
B2: =$A2*(1-B$1)

Copy that formula down through B100

Note: You can enter other discount percents across Row_1
and copy the formulas across.

Example:
C1: 12%
Copy the Col_B formulas into Col_C

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"mlhank" wrote in message
...
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?