Percentages - VAT

[Saxon]

Hi

I am looking for some help with an Excel Spread Sheet which is calculating
VAT at 15%.

I am using this to keep a track of invoicing.

At the end of a month I check all the outstanding invoices and my total is
out by 21p, this is caused by the rounding up/down of VAT.

Does anyone know how I can get my column total to ignore rounding up/down
and take the actual figure that is showing in the cell.

TIA

Saxon

 

[fake_be]

Hi Saxon,

Take the sum of the invoice and multiply it by the 15%VAT instead of
sum the VAT.

Good Luck,
Tom