% discount formulas?

[Marc Mercier]

I'm trying to make a sales/group-rate spreadsheet.
Column A would be the MSRP price, Column B would be 20% from MSRP. Column C
would be Column A minus 10% then 5% on top of that. I can't get the
combination to make it work and I feel stupid as it should be easy.

Ex:

MSRP 20% Disc 10%-5% discount
$500 $400 $427.50

Thanks for any help in this.

Marc

 

[Frank Kabel]

Hi
B1:
=A1*0.8

C1:
=A1*0.9*0.95

 

[Marc Mercier]

Gee.. basic math! I spent way too much time looking for fancy answers.
LOL! Thanks for the slap on the back of the head Frank! Formulas work
like a dream.

Marc

 

[Frank Kabel]

Hi Marc
you're welcome )