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)