1 Reply Latest reply on Jun 13, 2014 4:00 PM by philmodjunk

    Newbie formula question

    JeremyCarr

      Title

      Newbie formula question

      Post

           Hi, just starting with FM, trying to make the following formula in a calculation field work.

           All fields referred to are either Yes / No or Yes / No / NA

           Basically, if any field is NO then the calculation must be NO. If any field is Yes OR NA the calculation is Yes

           The problem I am unable to solve is that if any field is N/A then it overrides any other field that is NO and the result of the calculation is Yes!

            

           If (Ap1flperf="Yes" and Ap1sd="yes" and Ap1vent="Yes" and Ap1term="Yes" or Ap1flperf="N/A" or Ap1sd="N/A" or Ap1term="N/A";"Yes";"No")

           I am sure this is a simple error but any help appreciated!