Using the following formula to show reps commission
=IF(K4>250,((K4-250)/2),IF(K4<250,((K4-250)/25)*5))
This formula works great if there something in K4, but if it blank it show a negative 50. I am sure there is a term for blank cell or what the next statement should say.
Thanks
Bookmarks