Forum Discussion
Proper IF function - I can't figure this one out
I am trying to figure out a revenue projection and I can't figure this one out. I collect a % of my sales person's commission but IF they reach $12,000 in commission paid I stop collecting the % ...
Other words you'd like to pay MIN(12000, Sales*Percent), correct?
SergeiBaklan wrote:Other words you'd like to pay MIN(12000, Sales*Percent), correct?
Actually, I want the maximum company split (take) to be 12,000 from each sales person