M
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
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
Formulas work
)