datastudent
Board Regular
- Joined
- Sep 7, 2021
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Hi,
Please help me figure out the computation of the sales compensation based on the below formula and help me simplified it.
Please help me figure out the computation of the sales compensation based on the below formula and help me simplified it.
=IF(C145<=50%,0,IF(C145<=100%,(((C28*50%)*($D$65))+((C126-(C28*50%))*$E$65)),IF(C145<=200%,(((C28*50%))*($D$65))+((C28*50%)*$E$65))+((C126)-(C28))*$F$65)) |
C145 | sales performance % | 77.78% |
C126 | actual sales performance | 70 |
C164 | sales compensation payment | |
C28 | published sales budget | 90 |
D65 | qouta performance 0-50% | 0.1 |
E65 | qouta performance 51-100% | 0.2 |
F65 | qouta performance 101%+ | 0.3 |