CHECKING TO SEE IF YOU ARE IN BALANCE
This is a handy formula to double-check your balance sheet with:
It is often easier to type in the TRUE and FALSE components first
=IF(ROUND(C4,0)=ROUND(C6,0),"in balance","out of balance")
You have to round both cell references….
Once you have done this, if you change c6 to 99.5, C10 will display In Balance.
Tip: Always test both the true and the false components. Just because one works - that doesn't mean the other does.