Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You have your less than or equal tos reversed. You need:
You're using =<<=
You have your less than or equal tos reversed. You need:
You're using =<<=
Thanks - Problem solved!