next up previous contents index
Next: INT, XLINT Up: A. Function Reference Previous: IF   Contents   Index


INIT

Syntax: INIT(X1, X2)

X1 = initial value
X2 = iterative or subsequent value

INIT returns its first argument on the first recalculation pass and its second argument on all subsequent recalculation passes when SpreadScript is performing iterative recalculations.

Examples:

C5 = INIT(1, C5+1) C6 = INIT(1, C5*C6)

C5 = Cycle! if Iteration Limit = 0 C5 = N if Iteration Limit = N

C6 = Cycle! if Iteration Limit = 0 C6 = N! if Iteration Limit = N

Excel function: N/A


next up previous contents index
Next: INT, XLINT Up: A. Function Reference Previous: IF   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003