---
schema_version: "1"
id: a18174104b52b77e9873f959acacec088ef8ad61ae9aaf8aae6a44b8d50cfb7e
title: tier_payout
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_tier_payout.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_tier_payout.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 44cfc36bfe8dc3d59e114d56db05b14d9ec2acb1a5849687e9723e2a4a683fea
description: Returns a payout amount from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# tier\_payout

Returns a payout amount from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.

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

```
tier_payout(lookup_value, table, tiebreak_below, return_column)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| lookup\_value | Required | The value to look up in the range table. |
| table | Required | The range table to look up the value in. |
| tiebreak\_below | Optional | An expression that specifies how the function handles a lookup\_value that exists in multiple tiers. If you don't specify this argument, this function uses the tier with the lower value. |
| return\_column | Optional | The name of the range table's specific return column, enclosed in double quotes. This argument is required only if the range table includes multiple return columns, which is helpful when the same value ranges are used across multiple plans with different rates. |

## Considerations

You can use previously created summary calculations and mathematical operations in a range table. Reference these calculations with the syntax `WorksheetName!CalculationName`.

## Examples

A rep's attainment is 71.89%, which falls into an accelerator table's Tier 2, which pays 100%.

```
=tier_payout(RepAttainment, AcceleratorTable, false, "Accelerator")
```

![An example of the tier\_payout function with an accelerator table](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_function_ref_tier_payout.png)

#### See Also

- [Considerations for Accelerator Functions in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_functions.htm&release=264.0.0&type=5 "Salesforce Spiff provides several functions that support accelerators, including mamount(), mpercent(), range_lookup(), and tier_payout.")