DIFF returns the difference between two values and handles rollover.   

SYNTAX:

DIFF(FirstValue, LastValue, Optional rollover)

FirstValue: The value to subtract from.  Can be a constant, cell reference,cell range, or formula.

LastValue: The value to be subtracted from the First value.  Can be a constant, cell reference,cell range or formula.

Rollover:  Optional. The optional Rollover specifies the Rollover point.  If the optional parameter is not specified, the system assumes the rollover point is at the next power of 10.

 

EXAMPLES:

DIFF(5300,5000) = 300

DIFF(B3,LV(30034,1,3,7)) - Difference between value in B3 and the last value (LV function) for variable 30034.

DIFF(B3:B5,B6) - Difference between last value in cell range B3:B5 (i.e. looks at B5, B4, then B3) and the value in B6.

Download Example Template: Help_Diff.ss3 (Click here for download instructions)