Nested If statement in Script!

[nevilledhamsiri]

Hi Dear All!

I need to create a simple table box to arrange  how set of people have visited set of countries as per a set schedule & how the plan was changed & carried out the visits. In the process, based on the dimensions  I have created a if statement which gives some scripting errors while loading. Can some one see where I have gone wrong & correct me.

Thanks in advance

Neville

Date_Plan:

LOAD

[Person to visit],

  [place to visit],

  [Set Date Plan],

  [Person visited],

  [Place visited],

  [Ammended Dat Plan],

  IF( [Person to visit]= [Person visited] AND [Set Date Plan]= [Ammended Dat Plan],'ON_DATE_VISIT',IF( [Person to visit]= [Person visited] AND [Set Date Plan]> [Ammended Dat Plan],'ADVANCE_VISIT',

   IF( [Person to visit]= [Person visited] AND [Set Date Plan]< [Ammended Dat Plan],'LATE_DATE_VISIT' AND  IF( [Person to visit]<> [Person visited] AND [Set Date Plan]= [Ammended Dat Plan],'ON_DATE_SUB_VISIT',

   IF( [Person to visit]<> [Person visited] AND [Set Date Plan]< [Ammended Dat Plan],'LATE_DATE_SUB_VISIT', IF( [Person to visit]<> [Person visited] AND [Set Date Plan]> [Ammended Dat Plan],'ADVANCE_SUB_VISIT',

FROM (ooxml, embedded labels, table is Sheet1);

[Anonymous]

Immediately I can tell you haven't closed any of your parenthesis.

You should have at least 6 closing parentheses at the end if I counted right.

[nevilledhamsiri]

Please show me with explanation where it is wrong

Regds

Neville

[sunny_talwar · Accepted solution]

May be this

If([Person to visit] = [Person visited],

     If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_VISIT',

     If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_VISIT',

     If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_VISIT')))

If([Person to visit] <> [Person visited],

     If([Set Date Plan] = [Ammended Dat Plan], 'ON_DATE_SUB_VISIT',

     If([Set Date Plan] < [Ammended Dat Plan], 'LATE_DATE_SUB_VISIT',

     If([Set Date Plan] > [Ammended Dat Plan], 'ADVANCE_SUB_VISIT')))))