Accounting logical test to cross check columns and rows, not allowing pence

Hi all,

this is a very simple monthly accounts sheet, to show currency used, basically if I put all my expenses down for accounts to see, and I have a cross check to show things are calculated propperly, but unfortunatly they do calculate properly but the Logic test shows they don't.

I have hit a small problem with a simple formula that looks to see if all columns add up and checks this against the rows, if the rows all add to the same as the columns then all should be good, but the Logic test says they don't match.

I cell M32 is ..... =IF(D32-E32-F32-G32-H32-I32-J32-K32-L32=0,"","Check - totals do not balance!")

Now if the above cells in the sheet don't have decimals then it seems to work, but as soon as I start to use decimals then I hit problems and unfortunately I cant get my accounts to accept round numbers only and not worry about the pence.

Is this something to do with formatting ?

Excel is not calculating correctly, there are values in the 14th decimal, you see it if you use the Evaluate Formula button under the Formulas tab.
Try this:

Formula:

Please Login or Register  to view this content.

'''''''''''''