Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very Simple Question | Charts and Charting in Excel | |||
Simple question | Charts and Charting in Excel | |||
Follow on from simple question 12/8/2004 | Excel Discussion (Misc queries) | |||
Simple Question? | Excel Discussion (Misc queries) | |||
Simple VBA question | Excel Discussion (Misc queries) |