Hi all

Excel 97

I have a sheet like

A1........B1.............C1...............D1...... .........................E1....................... .....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