> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/ifnull.md).

# IFNULL

IFNULL( `value` )

Returns specified value if a value is null, returns specified `else` value otherwise.

### Arguments

| Argument | Description                                  |
| -------- | -------------------------------------------- |
| `value`  | Value or column potentially containing nulls |
| `then`   | Value to return if `value` is null           |
| `else`   | Value to return if `value` is not null       |

### Output

Outputs a series of values depending on if an element is null or not

### Example

{% embed url="<https://datawrapper.dwcdn.net/TUc28/1>" %}