Formula Engine Reference Guide
 

 

Back to Class Index

 

INIT(X1, X2)

Description
This function returns its first argument on the first recalculation pass and its second argument on all subsequent recalculation passes when Objective Grid is performing iterative recalculations.
 
Parameters
X1

initial value
 
X2
iterative or subsequent value
 
Examples
C5 = INIT(1, C5+1) C6 = INIT(1, C5C6)
 
C5 = Cycle! if Iteration Limit = 0, C5 = N if Iteration Limit = N
 
C6 = Cycle! if Iteration Limit = 0, C6 = N! if Iteration Limit = N