2 Replies Latest reply: Jul 30, 2010 1:15 PM by JAMESPAR RSS

    Nested IF statement - Error in expression:')' expected

      Hi,

      I am attempting a nested if statement with two conditions, but am receiving the following error message:

       

      Error in expression:')' expected



      Any ideas why this isn't working would be gratefully received.

      The statement is as follows:

       

      if

       

      ([Current Status]='Authorised' AND [No. Of days from date reported]=< 21,'On track',if([Current Status]='Processed' AND [No. Of days from date reported]=< 21,'On track',if([Current Status]='Checking' AND [No. Of days from date reported]=< 7,'On track',if([Current Status]='Draft' AND [NO. Of days from date reported]=< 7,'On track',if([Current Status]='Closed','Closed','Overdue'))))) as OnTrack,

      Thanks!