ISDEFINED function

ISDEFINED (Value) ISDEFINED (Value)

Value

The value to test.

Returns

Logical Logical

Whether the given parameter is defined.

Returns whether the given value is defined. ISDEFINED ( BLANK ()) ISDEFINED ( BLANK ()) returns FALSE.

This function is not commonly supported by spreadsheets.

Related functions

IFBLANK is a convenient way of returning a different value if a value is blank, or the value itself otherwise. This formula returns Value1 if it isn't blank, and 0 otherwise:

IFBLANK (Value1, 0)

IFBLANK (Value1; 0)

To check if a value is blank, use the ISBLANK function. Use the BLANK function to create a blank value.

ISDEFINED and arrays

Applying ISDEFINED to an array yields a logical array with the same size as the original array, where TRUE elements indicate that the corresponding element in the original array is defined and FALSE elements indicate the opposite.

This formula returns { FALSE, TRUE }{ FALSE; TRUE }, indicating that the first element is blank and the second element is defined:

ISDEFINED ({ BLANK (), 42 })

ISDEFINED ({ BLANK (); 42 })

Use AND to determine if all array elements are defined. This formula returns FALSE, as not all elements are defined:

AND ( ISDEFINED ({ BLANK (), 42 }))

AND ( ISDEFINED ({ BLANK (); 42 }))

Use OR to determine if one or more array elements are defined. This formula returns TRUE, as the second array element is defined:

OR ( ISDEFINED ({ BLANK (), 42 }))

OR ( ISDEFINED ({ BLANK (); 42 }))

Examples

ISDEFINED ( BLANK ())

Returns FALSE.

ISBLANK ( BLANK ())

Returns TRUE. Values which are not defined are blank, by definition.

IFBLANK (Value1, 0)

IFBLANK (Value1; 0)

Returns Value1 if it isn't blank, and 0 otherwise.

ISDEFINED ({ 4, "test", BLANK () })

ISDEFINED ({ 4; "test"; BLANK () })

Returns the array { TRUE, TRUE, FALSE }{ TRUE; TRUE; FALSE }, indicating that only the last element of the array is not defined.

{ 4, "test", BLANK () } == BLANK ()

{ 4; "test"; BLANK () } == BLANK ()

Returns FALSE, as the array { 4, "test", BLANK () }{ 4; "test"; BLANK () }, in and of itself, is not blank.

! ISEMPTY ( FILTER ({ 4, "test", BLANK () }, ISDEFINED (Element)))

! ISEMPTY ( FILTER ({ 4; "test"; BLANK () }; ISDEFINED (Element)))

Returns TRUE, as the array { 4, "test", BLANK () }{ 4; "test"; BLANK () } contains at least one defined element. FILTER returns an array containing the defined values, { 4, "test" }{ 4; "test" }. ISEMPTY, when applied to this array, returns FALSE to indicate that the array is not empty. The ! operator finally negates that return value, turning TRUE to FALSE and FALSE to TRUE.

OR ({ 4, "test", BLANK () } <> BLANK ())

OR ({ 4; "test"; BLANK () } <> BLANK ())

Returns TRUE, as the array { 4, "test", BLANK () }{ 4; "test"; BLANK () } contains at least one defined element. The <> operator returns the array { TRUE, TRUE, FALSE }{ TRUE; TRUE; FALSE }, indicating that the first two elements are defined, unlike the third element. OR finally returns TRUE, as there is at least one element in the array equal to TRUE.