Calculation based on a criteria

Well, this is my first post. Have gotten many answers from this site in the past.

I am probably just not searching properly with the right keywords. If anyone can point me to a resource in the right direction would be greatly appreciated.

I know I can do this with IF statements, is there an easier way?

I am looking to calculate a payout for a sales guy based on a few criteria.

If the Type of Service is PSA or Retrofit, payout sales rep 10% of total revenue.

If it is Repair, depending on margin percentage payout based on attached chart.

note:i will already have margin percentage calculated so that does not need to be calculated.

TIA

-Matt