Hi,
I am attempting to create a formula to work out commission paid based on a series of circumstances based on %age level of achievement:
TH 3,500
TA 10,000
GSA 20,000
WOD 2,000
CP
0 to TH 0%
TH to (TA*60%) 10%
(TA*60%) to TA 15%
TA + 20%
Am trying to create a formula that includes all the below:
If GSA <= TH Then 0
IF GSA >TH BUT <= TA*60% Then WOD*10%
IF GSA > TH*60% BUT <= TA Then WOD*15%
IF GSA > TA Then WOD*20%
Bookmarks