So I was able to figure out a a multi-cell solution to the following but I couldn't figure out how to combine it into one.

Basically I need a single formula that Calculates the following:


An entire sales bonus if an employee receives $500 if sales hit $750k and $500 more for every $100k in additional Sales. So an employee with $950k in Sales would receive a $1.5k bonus.

Any idea on how to do this?

Thanks!