4 Replies Latest reply on Nov 13, 2016 11:26 PM by Morgan DUARTE

    Help in formula - If match primary condition and secondary one then xx

    Morgan DUARTE

      Hi there,

       

      I'm working on an incentive plan and need your help to build a formula that works...

       

      I have 3 activities with a target and an actual value"

      Act1 = Target: 100, Actual: 90

      Act2 = Target:50, Actual: 60

      Act3 = Target: 40, Actual 30

       

      If they achieve Act1 + Act2 targets, they got 2%, if they achieve Act1 + Act3, they got 3% and if they achieve all, they got 5%

       

      So Act1 target is the primary condition. If they failed this, they don't get anything.

       

      How can I build a formula to display how much incentive they will get?

       

      Any ideas?

       

      Thank you !