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

[#1]

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!

[#2 · Accepted solution]

You have your less than or equal tos reversed. You need:

<=

You're using =<

[#3]

Thanks - Problem solved!