So, the commission structure is as follows:
Commission % 3.0% 3.5% 4.0% 4.5% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%
Current year value target $1.8 $2.5 $3.0 $3.5 $4.0 $5.0 $6.0 $7.0 $8.0 $9.0 $10.0
I need a formula that looks up (within a total contract value column, "O") to see if these TCVs fall in the 0-1.8 range. Because the commissions are based on aggregate numbers, the next column can't be this formula; it needs to sum the "Sales 0-1.8 "V" column that we just discussed up to 1.8 million and 1 cent, and once that has been reached, THEN it needs to return the sales that fall within this commission category. I am pulling my hair out over this...please help!
Bookmarks