| Author |
Quick Maths Q |
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
if a total is £29.38, and theres a 5% discount, what would the new total be?
need this for ict c/w
|
|
|
max99
Joined: Nov 24, 2004
Posts: > 500
From: Manchester (@ Uni)
PM |
£27.911
[addsig] |
solidsingh
Joined: Jan 15, 2004
Posts: > 500
From: india
PM |
29.38 x 0.95 = 27.91
|
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
also if anyone knows a formulae i could use to work out the final total
|
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
thanks max and solid 
i can get the formulae to equal 29.38, but im not sure how to reduce the price by 5%
|
solidsingh
Joined: Jan 15, 2004
Posts: > 500
From: india
PM |
((PPU*Q)*0.95)*1.175
|
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
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 ] |
solidsingh
Joined: Jan 15, 2004
Posts: > 500
From: india
PM |
your doing it wrong, the vat is the last thing that you calculate, the discount should be calcualted on the orginal price excluding vat
|
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
oh ok
so like this?
|
methylated_spirit
Joined: Jul 07, 2004
Posts: > 500
From: Bonnie Scotland
PM |
you're using a spreadsheet, it will do it all for you...
Hello, Scroto!
U.G.L.Y. You ain't got no alibi, you ugly! |
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
i no, i jus dunno what formulae to enter.
|
methylated_spirit
Joined: Jul 07, 2004
Posts: > 500
From: Bonnie Scotland
PM |
me neither 
Hello, Scroto!
U.G.L.Y. You ain't got no alibi, you ugly! |
solidsingh
Joined: Jan 15, 2004
Posts: > 500
From: india
PM |
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
|
anay
Joined: Sep 17, 2004
Posts: 296
From: London
PM |
or do i need to put "sub-total" between "discount" and "vat" to make it easier to calculate?
|
solidsingh
Joined: Jan 15, 2004
Posts: > 500
From: india
PM |
yeah with sub total equalling price * quantity
|
|
|
Posted: 2005-11-17 16:54
