On 01/07/2020 23:11, ss wrote:
On 01/07/2020 20:23, Robin wrote:
When I use.
(K10+L10-O10)*$P$77+TRUNC(0.758,2)
It returns 1.508

Eliminate refs to cells we can't see.Â* Paste in a cell

=ROUNDDOWN(0.199,2)

and report the result.


I dont quite understand your reply.

I meant that we cannot know just what your formula involves because it
uses cells in your worksheet. I suggested you test with a simple number
- 0.199 - to see if ROUNDDOWN works.

But I agree with others that it's not worth bothering about differences
of a penny or so. And if you really want to pursue it then you need you
to first work out which method your supplier is using to arrive at its
VAT total.

--
Robin
reply-to address is (intended to be) valid