Percentage Discount

  • Thread starter Thread starter barbiro
  • Start date Start date
B

barbiro

Hi, I'm a newbie and here's hoping someone here can help me.
I have 2 columns:

1) Retail Price
2) List Price

I need for column #2 to reflect the sum of 20% off the Retail Price.
can't figure out how to do the formula.

Also, does anyone know how I can "number" a column automatically?

I'm new at Excel but trying to pick up speed with it.

Thanks for any help :
 
=a2*80%

is one way. But if you put that discount in a dedicated cell (say $a$1), then
you could use:

=a2*(1-$a$1)

then you could play what if games by varying your discount.

I like to put =row() and drag down.

If I need to adjust the numbering (start in A7 with #1):
=row()-6
and drag down.
 
Back
Top