Posted by anay
if a total is £29.38, and theres a 5% discount, what would the new total be?
need this for ict c/w
Posted by max99
£27.911
Posted by solidsingh
29.38 x 0.95 = 27.91
Posted by anay
also if anyone knows a formulae i could use to work out the final total
Posted by anay
thanks max and solid
i can get the formulae to equal 29.38, but im not sure how to reduce the price by 5%
Posted by solidsingh
((PPU*Q)*0.95)*1.175
Posted by anay
sorry to be a pain, but could some1 work this out instead.
soory solid m8.
_________________
FREE Loose Change DVD: http://www.esato.com/board/vi[....]pic=99760&start=75#post1476113
[ This Message was edited by: anay on 2005-11-17 16:10 ]
Posted by solidsingh
your doing it wrong, the vat is the last thing that you calculate, the discount should be calcualted on the orginal price excluding vat
Posted by anay
oh ok
so like this?
Posted by methylated_spirit
you're using a spreadsheet, it will do it all for you...
Posted by anay
i no, i jus dunno what formulae to enter.
Posted by methylated_spirit
me neither
Posted by solidsingh
yes now this is what you need to type
Discount is (price x quantity) * Discount (%)
Vat is ((price x quantity) - discount) * 0.175
Final total is (price * quantity) - discount + VAT
Posted by anay
or do i need to put "sub-total" between "discount" and "vat" to make it easier to calculate?
Posted by solidsingh
yeah with sub total equalling price * quantity
Posted by anay
ok done
can anyone jus confirm these are right.
thanks for all the help solid
Posted by solidsingh
spot on
Posted by anay
thnx m8.
pm solid
Posted by methylated_spirit
i agree, spot on.