IFDEFINED function

  • 7 February 2024
  • 0 replies
  • 180 views

Userlevel 2
Badge +2
  • Community Manager
  • 3 replies

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

 

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

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, IFBLANKIF


0 replies

Be the first to reply!

Reply