3 Replies Latest reply on Apr 18, 2018 11:40 AM by Deepak Rai

    Help with else if formula

    Silvia Assuncao

      Hi!

      could someone help me with this formula?

       

      (sum(IF ([Company_Code])<>"F105" AND [Americas Category Subordinate] = "Consultant & Contract Labor" THEN ([Aop Lc]-[Estimate Lc])/(([USD Rate Year Average AOP]))

      ifelse ([Company_Code]) ="F105" AND [Americas Category Subordinate] = "Consultant & Contract Labor" then([Aop Lc]-[Estimate Lc])

      END))

      newformula.png