LinkBack URL
About LinkBacks
=1.5% * SUMPRODUCT((A1>{0,1,3,5,8}*1000000) * (A1-{0,1,3,5,8}*1000000) * {50,-25,-10,-5,-3}%)
The values {50,-25,-10,-5,-3}% are the differences in commissions between adjacent tiers.
=1.5% * SUMPRODUCT((A1>{0,1,3,5,8}*1000000) * (A1-{0,1,3,5,8}*1000000) * {50,-25,-10,-5,-3}%)
The values {50,-25,-10,-5,-3}% are the differences in commissions between adjacent tiers.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks