13 Replies Latest reply on Oct 23, 2014 4:35 AM by Nora Kelmendi Branched to a new discussion.

    'And' functions in 'If' statements

    Nora Kelmendi

      Hello,

       

      I am trying to write an 'If' formula using an 'And' function but it does not seem to be working:

       

      IIf([Level]="3" AND [Overall Pass Rate]<=0.6,"1",0)

       

      Is this possible?

       

      Nora Kelmendi