---
title: "Use the ISNOTBLANK Function to Check If a Value Is Defined"
slug: "isnotblank-function"
description: "Learn to use the ISNOTBLANK function in Pigment to identify non-empty values and improve data validation."
updated: 2025-05-30T09:38:42Z
published: 2025-08-22T10:57:28Z
---

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

# ISNOTBLANK function

## ​​​Description

Returns TRUE if the given Value is defined, otherwise it returns FALSE.

> [!TIP]
> For improved performance, we recommend that you use the [ISDEFINED function](/v1/docs/isdefined-function) if possible.
> 
> - `ISNOTBLANK` Returns TRUE or FALSE. This function populates all cells of the property or Metric. The result is 100% density, and can impact performance.
> - `ISDEFINED` Returns TRUE or BLANK. Any cells that are equal to FALSE remain unpopulated. The result is sparse, which means less data and less time required to write the result in the database. This prevents max cardinality and timeout errors.

## Syntax

`ISNOTBLANK(Value)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Value* (required) | Any | Any |  |

## Returns

| Type | Dimensions |
| --- | --- |
| Boolean | Dimensions of argument *Value* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `ISNOTBLANK(1)` | TRUE | 1 is not `BLANK` |
| `ISNOTBLANK(BLANK)` | FALSE |  |
| `ISNOTBLANK(MyMetric)` |  | `BLANK` values of MyMetric return FALSE while non-`BLANK` values return TRUE. |

## See also

Excel: [IS](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)

Related articles: [ISBLANK](/v1/docs/isblank-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>