G
Guest
I need some help with a formula calculating a sales commission. Can someone
assist?
Let's say the net income in cell A2 is $25,000 for the period.
The payout is:
25% of the first $2990
35% of the next $8250
50% of anything over $11,240
On another note ... how do I make a cell show as ZERO when the number is a
negative one. I am trying to format some different cells.
Thank you,
Keb
assist?
Let's say the net income in cell A2 is $25,000 for the period.
The payout is:
25% of the first $2990
35% of the next $8250
50% of anything over $11,240
On another note ... how do I make a cell show as ZERO when the number is a
negative one. I am trying to format some different cells.
Thank you,
Keb