You could use DIVIDE to determine the average monthly bonus of your sales team.
Syntax
DIVIDE(Dividend, Divisor)
Arguments
| Argument | Data type | Description |
| Dividend | Number | The number to divide. |
| Divisor | Number | The number to divide by. |
Syntax example
DIVIDE(Commission, 7)
| Lee | Smith | Cho | Ako | Khan | Knor | Patel | |
| Sales Revenue | 50,000 | 68,000 | 62,500 | 88,000 | 98,600 | 92,000 | 74,230 |
| Commission Ratio | .05 | .05 | .08 | .07 | .05 | .06 | .07 |
| Commission | 2,500 | 3,400 | 5,000 | 6,160 | 4,930 | 5,520 | 5,196 |
| Ave. monthly commission | 208.3 | 283.3 | 416.6 | 513.3 | 410.8 | 460 | 433 |
Excel equivalent
Detailed Examples
| Result | |
DIVIDE(50,5) | 10 |
DIVIDE(750,000,200) | 3,750 |
DIVIDE(30,0) | Infinity |
DIVIDE(-45,0) | -Infinity |