Home : DIFF
Q11216 - INFO: DIFF

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)

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/9/2008 4:16 PM.
Last Modified on 5/9/2008 5:28 PM.
Last Modified by Scott Dorner.
Article has been viewed 2864 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article