ISBLANK function

Prev Next

​​​Description

Returns TRUE if the given Value is BLANK, FALSE otherwise.

Syntax

ISBLANK(Value)

Arguments

Argument

Type

Dimensions

Description

Value

(required)

Any

Any

Returns TRUE boolean if value is BLANK

Returns

Type

Dimensions

Boolean

Dimensions of argument Value

Examples

Formula

Result

Description

ISBLANK(1)

FALSE

1 is not BLANK

ISBLANK(BLANK)

TRUE

ISBLANK(MyMetric)

BLANK values of MyMetric return TRUE while non-BLANK values return FALSE.

See also

Excel: IS

Related articles: ISNOTBLANK, IFBLANK, IF

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!