Hi there,

I am trying to do a formula based on a tiered system. So an employee gets paid out per deal based on how many deals they get. See example below. So for February they would get paid out $300*4=$1,200 based on hitting tier 2 for 3 or more deals but less than tier 3 for DCI Deals and $400*10=$4,000 for Certainli Deals for hitting tier 3, 10 deals or higher giving them a total of $5,200 bonus that month. Any help is appreciated, thank you so much!!

 Tier 1Tier 2Tier 3DCI $      150.00 $      300.00 $      600.00Certainli  $      100.00 $      200.00 $      400.00 Tier 1Tier 2Tier 3DCI036Certainli0510 JanuaryFebruaryMarchAprilMayJuneJulyAugustDCI Deals34642313Certainli Deals510523521

​Hi there,I am trying to do a formula based on a tiered system. So an employee gets paid out per deal based on how many deals they get. See example below. So for February they would get paid out $300*4=$1,200 based on hitting tier 2 for 3 or more deals but less than tier 3 for DCI Deals and $400*10=$4,000 for Certainli Deals for hitting tier 3, 10 deals or higher giving them a total of $5,200 bonus that month. Any help is appreciated, thank you so much!! Tier 1Tier 2Tier 3DCI $      150.00 $      300.00 $      600.00Certainli  $      100.00 $      200.00 $      400.00 Tier 1Tier 2Tier 3DCI036Certainli0510 JanuaryFebruaryMarchAprilMayJuneJulyAugustDCI Deals34642313Certainli Deals510523521  Read More

​