---
title: "Use the ISBLANK Function to Return TRUE for Empty Values"
slug: "isblank-function"
description: "Learn to use ISBLANK to check for empty values in Pigment. Returns TRUE if the value is BLANK, FALSE otherwise."
updated: 2025-05-30T09:38:33Z
published: 2025-08-22T12:00:18Z
canonical: "kb.pigment.com/isblank-function"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ISBLANK function

## ​​​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](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)

Related articles: [ISNOTBLANK](/v1/docs/isnotblank-function), [IFBLANK](/v1/docs/ifblank-function), [IF](/v1/docs/if-function)

> [!TIP]
> 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!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>