I've searched the forum for the answer to this question, and I know it can be
done, I just haven't done it in a long time.

I'm trying to create a conditional formula that will allow me to have more
than one result. This is for tracking bonuses for the salespeople in our
company. For example, I want to have a column with the salesperson's name,
then a column where I will input their sales figures. I'd like for the bonus
column to auto fill with the desired amount. For example, less than $1000
results in no bonus, between $1000 and $5000 is a $100 bonus, et cetera. Is
this possible?