...
Acts as a simple IF statement to determine what to do when the supplied expression supplied to it is _NULL or not. Specifically it It checks the value returned by the first expression provided, if this is _NULL the second expression will run, and if it is not _NULL the value in the initial expression is used. An optional third expression can be provided that will run . If the third statement is blank the expression will do nothing and continueif the first expression is not blank, instead of simply returning the non-null value.
Syntax
- ifNull(expression, nullReturnValue)
- ifNull(expression, nullReturnValue, notNullReturnValue)
| Argument | Type | Description |
|---|---|---|
| expression | Any | The expression to be evaluated and checked. If notNullReturnValue is not provided, then this is also used as the return value for the function if expression does not evaluate to _NULL. |
| nullReturnValue | Any | The value to be returned if expression is _NULL |
| notNullReturnValue | Any | An optional parameter containing the value to be returned if expression does not evaluate to _NULL. |
...