Penny rounding!

  • Thread starter Thread starter rozbat
  • Start date Start date
R

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)
 
rozbat said:
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).
Click to expand...

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
 
Back
Top