Formula Help

[ghuber34]

I can't seem to get the formula right.

It is a salesperson bonus

I have the over margin dollars in J7. (this could be a negitave number)

I wanted to write a formula using J7 number.

IF J7 is less than 0 = 0
IF J7 is greater than 0 but less than 50,000 they get 7.5% commission of J7
IF J7 is greater than 50,000 they get 7.5 % of the first 50,000 and 5% of the amount over 50,000

Thanks for any help

[satabp]

=if(j7<=0,0,if(j7<50000,7.5%*j7,(50000*7.5%)+((j7-50000)*5%)))

[bebo021999]

Try this:
=IF(J7<0,0,IF(J7<50000,J7*7.5%,J7*5%-1250))

[satabp]

Try this:
=IF(J7<0,0,IF(J7<50000,J7*7.5%,J7*5%-1250))

It should be +1250

=IF(J7<0,0,IF(J7<50000,J7*7.5%,J7*5%+1250))

[ghuber34]

Thank you all this was helpful and worked perfect.