Conditional Formatting working when it shouldn't!

Hello,

I created a spreadsheet which helps us at work with the cashing up. It compares money in the tills and the print outs from the card machines (Z-reads) to what our software says. This can all be done with a calculator and pencil, but it just saves time at the end of the night.

At the bottom, (A24:J29) is where it compares the figures to see if it matches. I have set it to highlight the row, if it doesn't balance, using conditional formatting. Also, in H24:H29, I have put in some simple IF formulas to say which way round it is out - i.e. if it is £10 out, then does the card machine have £10 too much or our software. If it balances it stays blank.

All is working, except that one of the rows is applying the conditional formatting, and the formula in column H to say that the till is down, even though it balances. One other thing I found is that in J18, where it says if there are any till discrepancies, it shows the amount as -£0.00. This should not have a negative as far as i can see.

I can easily resolve this by starting again - it wouldn't take very long, but I would love to know what is causing the issue!

Thank you.

Check out the links on this post for information on Excel's floating point arithmetic, and why there are times it seems really screwy.

Great, thank you for the link, I will take a look.
As always, those on this website comes to the aid of us 'Excel novices' brilliantly.