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

    If Statement with And Opperator



      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.