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



      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