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

Don't know if you are the same person as Dixie?

http://www.mcgimpsey.com/excel/variablerate.html

--
Regards,

Peo Sjoblom


"Keb" wrote in message
...
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