I used a <> to compare the two figures going in both directions.
First to compare the computer figures to the batch out from the C/C. Then from the C/C batch to the computer figures.
That way it doesn't matter witch entry you make first, it still compares the two.
This is the formula I used. It's modified from a Microsoft demo page.
=IF(OR(C32<>C33, C33<>C32), "Out of Balance, Check Figures", "Balanced")
If the figures match, it returns a "true" and "Balanced" is shown in the cell under the totals. If the figures don't match, then it returns a "false" and "Out of Balance, Check Figures" is shown.
While it doesn't show which one or how much it's off, it does alert the person entering the daily figures that something is wrong and they need to go back and check the figures.
The rest of the sheet is finished, if I'd stop tinkering with it and adding more to it. I'm just wanting to have some built in checks and balances that are not obvious except to those that know what they're looking at. Too many managers have come through our properties that have had their hands in the till. I want to trip them up by having the spread sheet rat them out and them not know it.