---
schema_version: "1"
id: 8f72e2b2f04909c8a400c801150de3ed4abfa0bce63cb0a4e09e6c766d460fac
title: ifnull
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_ifnull.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_ifnull.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e40600befadf54e1d7a4b22599bf930c9afbe5a7a930eacecddf39bbe567067c
description: Replaces a null value in a field with a specified value in Salesforce Spiff.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# ifnull

Replaces a null value in a field with a specified value in Salesforce Spiff.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Syntax

```
ifnull(field, if_null_value)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| field | Required | The field to check for a null value. |
| if\_null\_value | Required | The value to use for the field if the current value is null. |

## Example

Check whether the ARR\_\_c field is null, and replace any null values with `0`.

```
=ifnull(ARR__c, 0)
```