---
schema_version: "1"
id: bdfb6479b7b6a7c6a4fb90547f548aae59664014dc69f2ebfaaaaa64f436b633
title: ifs
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_ifs.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_ifs.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 683d048311dc95a5607b02aa071a6c7bb33ea44aa20049b487b40eadfaeee883
description: Returns the first true result from a series of logical tests in Salesforce Spiff. This function is similar to multiple if() functions. You can include multiple conditions and return different values based on the result of each condition.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# ifs

Returns the first true result from a series of logical tests in Salesforce Spiff. This function is similar to multiple if() functions. You can include multiple conditions and return different values based on the result of each condition.

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

```
ifs(list_of_condition_value_pairs)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| list\_of\_condition\_value\_pairs | Required | A list of each condition to test and each value to return, enclosed in brackets and separated by commas, such as `[condition 1, value 1, condition 2, value 2]`. |

## Example

A rep is paid a commission rate for each opportunity, but the rate depends on the opportunity's ARR.

- If the ARR exceeds $30,000, the rep receives a 10% rate.
- If the ARR is under $20,000, the rep receives an 8% rate.
- If the ARR is under $10,000, the rep receives a 6% rate.

```
=ifs([ARR >= 30000, 10%, ARR >= 20000, 8%, true, 6%])
```

Because this function returns the first condition that's true, carefully arrange your test conditions so that the most exclusive condition is first. If the ARR is greater than $30,000, both the first and second conditions are true, but you make to make sure that you return the 10% rate, not 8%.

To provide a catch-all condition or fallback value when all other conditions are `false`, the last condition can always be `true`.

#### See Also

- [if](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_if.htm&release=264.0.0&type=5 "Tests for a condition in Salesforce Spiff and returns different values depending on the outcome.")