View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WebLord
 
Posts: n/a
Default Simple Question, Calculating Discounts

Hello,

I just have what I think is a simple question regarding calculating
discounts with percentages. Sorry to bother you all with something so
basic, but I really am having a hard time with it and can't

I am basically trying to calculate a price on a vehicle after a
discount of 10% off the sticker price, then add a 6% sales tax, then
subtract another 5% as the downpayment. Once I can calculate this
number,which would be the amount to finance, I can use the PMT
function- which I somewhat understand.

Sticker Price 15000
Discount 10%
Sales Tax 6%
Downpayment 5%
Amount to be financed ??? =$C$3-$C$4+C$5$-$C$6

I know this is the wrong formula, and the answer acts as if the
percentages were pennies on the dollar? Do I need to format the cells
differently or what the hay am I doing wrong?

Thank you for reading!!!