# R.PROPORTION
## Content
This function is used to get the proportion of cell values.
## Syntax
`R.PROPORTION(ValueCell, [ContextCell1], [ContextCell2])`
## Arguments
This function has the following arguments.
| **Argument** | **Description** |
| -------- | ----------- |
| *ValueCell* | [Required] Specify the cell for which value you want to get the proportion. |
| *ContextCell1* | [Optional] Specify context cell 1, which usually is the year cell.
Example:
If the A2 cell is bound to the year column, B2 cell is bound to the month column, C2 cell is bound to the sales column, then,- R.PROPORTION(C2) will return the current sales proportion in all years' sales.
- R.PROPORTION(C2, A2) will return the current sales proportion in current year sales.
|
| *ContextCell2* | [Optional] Specify the context cell 2.
If the value cell is a cross cell, this argument must be specified. |
**Example 1: The value cell is a normal cell**
Template:
Preview:
**Example 2: The value cell is a cross cell**
Template:
Preview:
