Disounts Help Please
John,
Try
D1: =A1*(B1-(B1*C1))
E1: =D1*17.5%
F1: =D1+E1 or simply =D1*(1+17.5%)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
wrote in message
...
Hi all
Excel 97
I have a sheet like
A1........B1.............C1...............D1...... .........................E
1............................F1
qty....unit cost..... discount... total with discount...
vat..........................total with vat at 17.5%
1........£100...............30.00%..........£70... ....................£12.25
......................£82.25
Now what I cannot find out how to do is this
In D1
Take B1 then multiply by A1...... then take C1 off
I have put it like this =(B1*A1)*C1 BUT that does not work. Because it
gives me £30.00 and it should be £70.00
Also how would I put in F1........ B1 plus A1 less C1 multiply by 17.5%
to give me a grand total
As always, any and all help is greatly appreciated.
Thank you in advance.
John
|