ISEMPTY function

ISEMPTY(Array) ISEMPTY(Array)

Array

{ ? }

The array to check.

Returns

Logical

Whether the given array is empty.

Returns whether the given array is empty. ISEMPTY({})ISEMPTY({}) returns TRUE and ISEMPTY({ 1, 2, 3 })ISEMPTY({ 1; 2; 3 }) returns FALSE.

Use SIZE to determine the number of elements in an array. This function returns TRUE only if SIZE, when applied to the same array, returns 0.

Examples

ISEMPTY({})ISEMPTY({})

Returns TRUE.

ISEMPTY({ 1, 2, 3 })ISEMPTY({ 1; 2; 3 })

Returns FALSE.

SIZE({ 1, 2, 3 })SIZE({ 1; 2; 3 })

Returns 3.