Sarah,

Your welcome and thanks for the feedback.

Mike

"Sarah@LaborSource" wrote:

THanks Mike. Don't exactly understand it all, but it worked like a charm.
Sarah

"Mike H" wrote:

To work out the commision on A1 try this

=IF(A1<150000,A1*0.0125,IF(A1<200000,A1*0.0175,A1* 0.025))

Mike

"Sarah@LaborSource" wrote:

Hello. I am trying to create a formula to calculate commissions. I need to
make a formula that says:

If sales are below $150K, commission is 1.25%. If sales are $150-$200,
commission is 1.75%. If sales are above $200, commission is 2.5%.

Thanks!
Sarah