VAT Calculation

[NWE]

H

I am trying to calculate the VAT on an invoice. I am using the code =(RoundCC([Total]*0.175)) with [Total] being the vatable amount . This works fine apart from when the pence part is half a pence ie 0.625 resulting in the calulation being rounded down to 0.62 instead of up to 0.63. I would be very grateful if anyone could advise how to correct this.

Regard
NW

 

[Allen Browne]

The accepted practice is to round towards the nearest even, so .625 should
be rounded down to .62, but .635 should be rounded up to .64 (the nearest
even).

That's how the Round() funtion is supposed to work in Access 2000 and later
(but in reality you may have to CCur() before the Round() to get that to
work for all values).

RoundCC() is not a built-in function, so it is a little difficult to comment
on how it actually works.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am trying to calculate the VAT on an invoice. I am using the code

=(RoundCC([Total]*0.175)) with [Total] being the vatable amount . This works
fine apart from when the pence part is half a pence ie 0.625 resulting in
the calulation being rounded down to 0.62 instead of up to 0.63. I would be
very grateful if anyone could advise how to correct this.