9 Replies Latest reply: Mar 24, 2015 6:49 PM by Brenna Craft RSS

    If Statement with And Opperator

      Hi,

       

      I'm trying to include an AND operator in my IF statement, but I'm getting the error: ')' expected from the below bit of script. The first line works perfectly and is just an example of what I'm trying to do.

       

      IF("Success Percentage" >= .76, 1, 0) AS '76-100',

          IF("Success Percentage" =< .75 AND "Success Percentage" >= .51, 1, 0) AS '51-75'

       

      I'd be grateful for any assistance.