Best Microsoft Excel Bloggers

Tuesday, April 13, 2010

USING IF and ROUND Functions to Check Balances


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.


No comments:

Post a Comment


Ms. Excel- Resident Excel Geek