Description
Fills the defined values of an expression with a given value.
Syntax
IFDEFINED(Expression containing values, Value if defined, Value if blank )
Arguments
| Argument | Type | Description |
|---|---|---|
| Expression containing values (required) | Any | Expression containing Values. |
| Value if defined (required) | Any | Expression containing value you want to fill if the argument Expression containing values contains values. This needs to be the same type as the argument Value if blank. |
| Value if blank (optional) | Any | Expression containing the value you want to fill if the argument Expression containing values contains no values ( This needs to be the same type as the argument Value if defined. This is an optional argument, so if no value is provided for this argument, it returns |
Returns
| Type | Output Structure (Dimensions) |
|---|---|
| Same type as Value if defined / Value if blank | All Dimensions in the arguments Expression containing values, Value if defined, Value if blank. |
Examples
| Formula | Result | Description |
|---|---|---|
|
|
| Value 1 is defined, fill with |
IFDEFINED (1, TRUE) | TRUE | Value 1 is defined, fill with TRUE |
Excel equivalent: IF(NOT(ISBLANK(cell)), value if true, value if false)