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?