Formula to calculate commission before quota and after quota

In the future, try using Go Advanced > Manage Attachments to pull up the attachment uploader. It tends to be the most reliable way to attach a sample workbook.

Based on what you've posted, it seems like you're trying to calculate two things in one column. One calculation would show the projected bonus based on 1/4 of the yearly quota, the other would show the actual bonus based on entirety of the yearly quota. If my understanding is correct, I would recommend using two columns. For the "Projected Bonus" column, you could use what you have, and for the "Actual Bonus" column, you could use something like the following in row 17, filled down:

=MIN($E17,MAX(SUM($E$17:$E17)-$B$21,0))*0.25

Experiment a bit with the attachment to see if it works as desired:

Good deal.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.