Calculation based on a criteria

**hoosier5** · 10-25-2011, 08:50 AM

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

**Domski** · 10-25-2011, 09:14 AM

Maybe like in the attached.

Built this in 2003 but in 2007 you can use this as the formula in C10:

=IFERROR(VLOOKUP(A10,$A$2:$B$4,2,FALSE),VLOOKUP(B10,$D$2:$E$5,2,TRUE))

Dom

**Domski** · 10-25-2011, 09:26 AM

Donald,

Have you maybe posted that to the wrong thread?

Dom

**hoosier5** · 10-25-2011, 10:40 AM

Originally Posted by Domski

Maybe like in the attached.

Built this in 2003 but in 2007 you can use this as the formula in C10:

=IFERROR(VLOOKUP(A10,$A$2:$B$4,2,FALSE),VLOOKUP(B10,$D$2:$E$5,2,TRUE))

Dom

Domski-

Thanks. This worked perfectly.

Quick responses. I will be back.