 Formula Engine Reference Guide |
|
Back to Class Index
IF(X, T, F)
This function returns the value of T if X evaluates to non-zero, or F if X evaluates to zero. This function is included only for compatibility with other spreadsheets. In Stingray Grid for Microsoft .NET, IF is identical to X?T:F, which is more efficient to evaluate.
Parameters
X
A numeric value
T
A value
F
A value
Examples
IF(A1, 7, 9) = 7
where A1 = 1
IF(B17==0, 0, "non-zero") = "non-zero"
where B17 = 1