---
schema_version: "1"
id: 1087ea51dc54fe1e28eb3d14da33f6cac7be2d4933536669b5149027cce3e835
title: mamount
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_mamount.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mamount.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7bea8787a0ea31a53ee4386b91d2b542d980f50cbaa9e6bb279dbb0aea24a8fc
description: Returns the commission total for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission rate instead, use the mpercent() function.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# mamount

Returns the commission total for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission rate instead, use the `mpercent()` function.

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

```
mamount(input_value, range_table, initial_value, return_column)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| input\_value | Required | The amount to check against a range table, such as the ARR from a closed deal. |
| range\_table | Required | The range table to check. |
| initial\_value | Optional | A starting value that affects which ranges the input\_value applies to. Typically, this value is based on an accumulated variable, which tracks progress toward rate tiers. |
| 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

- This function calculates commission-specific amounts based on a rangle table and rate tiers.
- This function allocates input\_value across tiers by calculating how much falls within each tier range, calculates the payout for each tier, and sums the results.
- You can use previously created summary calculations and mathematical operations in a range table. Reference these calculations with the syntax `WorksheetName!CalculationName`.

## Example

Consider these commission rate tiers in a range table, MarginalPayoutRangeTable.

- For the first tier of ARR closed, $0 to $150,000, a rep receives 4% commission.
- For the second tier of ARR closed, $150,000 to $250,000, a rep receives 8% commission, but that rate applies only to this tier. The first $150,000 is still commissioned at 4$.

If a rep closes $145,000 in ARR and then closes a new deal with $20,000 in ARR, only $5,000 of the new deal is allocated to the first tier at 4%. The remaining $15,000 is allocated to the second tier at 8%. The result is a blended rate, based on this calculation.

```
0.04 * 5,000 + 0.08 * 15,000)/20,000 = 7%
```

To calculate this commission total, provide these values to the `mamount()` function.

```
=mamount(20000, MarginalPayoutRangeTable, 145000)
```

This function returns the commission amount of $1,400, which is the 7% blended commission rate forthe $20,000 deal.

#### See Also

- [mpercent](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mpercent.htm&release=264.0.0&type=5 "Returns the commission rate for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission total amount instead, use the mamount() function.")
- [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.")
- [Accumulated Variables in Accelerator Functions](https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_accumulated_variable.htm&release=264.0.0&type=5 "An accumulated variable is often used with the initial_value argument in the mamount() and mpercent() accelerator functions in Salesforce Spiff.")
- [Create an Accumulated Variable for a Marginal Payout Function](https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_accumulated_variable_create.htm&release=264.0.0&type=5 "Create an accumulated variable for the initial_value argument in the mamount() and mpercent() accelerator functions in Salesforce Spiff.")