4 Replies Latest reply on Nov 18, 2016 12:50 PM by Chris McClellan

    Question regarding Syntax Error

    Johnson Stalen

      For the below formula i am geeting syntax error...Please help

       

      IIF([Arrears]<=0,"Not due",IIF(AND([Arrears]>0,[Arrears]<=30),"Overdue 1-30",IIF(AND([Arrears]>30,[Arrears]<=60),

      "Overdue 31-60",IIF(AND([Arrears]>60,[Arrears]<=90),"Overdue 61-90",IIF(AND([Arrears]>90,[Arrears]<=180),

      "Overdue 91-180",IIF(AND([Arrears]>180,[Arrears]<=360),"Overdue 181-360","Overdue > 360")))))))

       

      Regards,

      Johnson Stalen