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

M

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?
 
G

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.
 
R

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)
 
J

JR

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

COLUMN E = PRICE

COLUMN F = % DISCOUNT

COLUMN G = PRICE - % DISCOUNT
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top