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

[mlhank]

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?

 

[Gord Dibben]

Assuming the prices are in column A

In B1 enter =A1*.8

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

 

[Ron Coderre]

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)

 

[JR]

HMM... THE FORMULA DIDN'T WORK FOR ME.

COLUMN E = PRICE

COLUMN F = % DISCOUNT

COLUMN G = PRICE - % DISCOUNT

 

[Fred Smith]

Then you entered incorrectly, as the formula is correct. You did adjust it
to reflect the location of your data, right? If not, given the new
information on where your data is located, in column G you would need:
=e1*(1-f1)
Copy down.

Regards,
Fred