# ISBLANK

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function tests whether a value, an expression, or contents of a referenced cell is empty.

## Syntax

ISBLANK(*cellreference*)
ISBLANK(*value*)
ISBLANK(*expression*)

## Arguments

Specify a cell reference, a numeric or text value, or an expression for the argument.

## Remarks

Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.
This function returns TRUE if the value refers to an empty cell or to no data.

> type=note
> **Note:** Spread's implementation of functions generally tries to follow the behavior found in popular spreadsheet applications. However, not all these applications agree whether the empty string "" should be treated the same as an empty cell. In Spread, both the [COUNTBLANK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCOUNTBLANK) and ISBLANK functions consistently treat the empty string "" differently than an empty cell.

## Data Types

Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

## Examples

`ISBLANK(B1)`
`ISBLANK(A4)`
`ISBLANK(A4-52)`
`ISBLANK(4)` gives the result FALSE

## Version Available

This function is available in product version 1.0 or later.

## See Also

[COUNTBLANK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCOUNTBLANK) \| [ISERROR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISERROR) \| [ISREF](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISREF) \| [ISTEXT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISTEXT) \| [Information Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsinfo)