f3[total column]=(F1 [qty column] x F2 [price column]) for example.
yer s**ttin me right?
^ lol, a school bursar asked me the other day how she could work out 20% of col A. If she worked for me I would have sacked the idiot.
=SUM(B3*C3)
Assuming B column is quantity and C column is price.
(The "3" is just the row I used for the example)
ok heres one for ya if i copy the formula down it will display £0.00 in all cells unless i enter a value in the quantity cell and price cell, How do I get the formual to still apply but not show £0.00 in the other cells?
Need to add up vat how do I do it?