CheckSum

Checksum validates that two values (sum, amount, calculation) contained within a spreadsheet are equal, less than zero or greater than zero, according to choice.

In Windex Financial Ratios the balance sheet spreadsheet uses CheckSum to validate that two sides of the balance sheets are equal, as follows: (Conditional messages are always placed between quotation marks):

=IF(SUM(C75:E75)<>0,"ERRORS!!","NO ERRORS")

The IF command is used to measure variances between two balance sheets and advise the user.

Action notes n the Core Ratios report in Windex 2:

=IF(G16<E16,"WORSE", "OK").

G16 is the return on capital employed from period 1, and E16 is the return on capital employed from period 2.