Penny rounding!

[rozbat]

Thanks Gordon, but column 2 is not a function of column 1. The tw
amounts have come from separate places, and the need is to find out i
column 2, the VAT paid, has been the correct amount ( or if we owe the
more)

 

[JE McGimpsey]

One way:

C2: =ROUND(B2/A2,3) = 0.175

 

[Gordon]

Thanks Gordon, but column 2 is not a function of column 1. The two
amounts have come from separate places, and the need is to find out if
column 2, the VAT paid, has been the correct amount ( or if we owe
them more).

So these numbers are being generated from your Sales ledger then? Presumably
you set the VAT rate in your sales ledger invoicing parameters? Are your
invoices correct? If so, then surely column 2 WILL be correct. If you still
need to check the VAT calculation, then you could put in column 3 something
like IF(A2<>A1*17.5%,1,"").
This will put a "1" in the cell if column 2 is NOT equal to 17.5% of column
1, and a blank if it is.

HTH