Use the IFDEFINED Function to Fill Values in an Expression

Description

Fills the defined values of an expression with a given value.

IFDEFINED(Expression containing values, Value if defined, Value if blank )

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 (`BLANK`). 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 `BLANK`.

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 (BLANK).

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 BLANK.

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.

Formula	Result	Description
`IFDEFINED (1, TRUE, FALSE)`	`TRUE`	Value 1 is defined, fill with `TRUE`.
`IFDEFINED (1, TRUE)`	`TRUE`	Value 1 is defined, fill with `TRUE`

Excel equivalent: IF(NOT(ISBLANK(cell)), value if true, value if false)

See also: ISDEFINED, IFBLANK, IF