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