<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=371557583225568&amp;ev=PageView&amp;noscript=1">

Excel FAQ Check Figure

Excel Tip: Check Figure

Double check totals for accuracy using the Check Figure formula.
Check Figure formula can be inserted as a row below each total and easily hidden from view when the report is complete.


Formula: '=IF(SUM(E16:E25)=E26,"",SUM(E16:E25)-E26)

check figure screenshot

Comments

0 Comments