Summing VAT does not add up : Solved

[bigmonmulgrew]

Hi guys

I have a spreadsheet to keep track of customer accounts.
Each row represents one invoice. with
Invoice number, Date, Grace Period, Due Date, VAT Rate , Pre VAT, With VAT, Status
Bold items are calculated automatically
Status can be - paid, Invoiced, refunded, or overdue.

Now at the top of the workbook is the following
Account Total - a sum of all money gone through the account in its lifetime
Paid - a sum of ammounts which have been paid.
Outstanding. - Account Total - Paid

Now the problem I am having is that the paid amount does not add up.
For example with one particular customer it should say £6999.85
But instead it says £6999.87
Now I think its due to how VAT is calculated.
For example £1.11 is £1.30 with VAT but 1.11*1.175 is 1.30425
It shows correctly in the VAT column but I'm sure the £0.00425 is throwing out the sum.

Any ideas

[floris_v]

Instead of amount*1.175 try round(amount*117.5)/100.

If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum

[bigmonmulgrew]

Excellent I knew there must be something like that available
Cheers buddy

SOLVED!!