problem in converting excel formula into load editor

[#1]

Hi, i have problem in converting the excel formula into load editor,

  =IF(EXACT(G2,""),"Not Started", IF(H2<=TODAY(),"Completed",IF(G2<=TODAY(),"In-Progress_Start",IF(F2<=TODAY(),"In-Progress_Tender",IF(E2="","Not Started",IF(E2<=TODAY(),"In-Progress_PEP","Not Started"))))))

This is what i have try, but there is error

IF("Start"=(''),('Not Started'),IF("End" =('<='TODAY()),('Completed'),IF("Start"=('<='TODAY()),('In-Progress_Start'),IF("Tender"=('<='TODAY()),('In-Progress_Tender'),IF("PEP"=(''),('Not Started'),IF("PEP"=('<='TODAY()),'(In-Progress_PEP'),('Not Started')))))) as "Status_try",

Thanks in Advance:)

[undergrinder · Accepted solution]

Hi Lingling,

I think you are using more paranthesis, than it should be.

Try this:

IF("Start"='', 'Not Started',

       IF("End" <= TODAY(),'Completed',

            IF("Start" <= TODAY(),'In-Progress_Start',

                 IF("Tender"<= TODAY(),'In-Progress_Tender',

                      IF("PEP"='','Not Started',

                           IF("PEP" <= TODAY(),'In-Progress_PEP','Not Started')))))) as "Status_try",

G.

[#3]

Thank you so much for your help:)

[undergrinder]

You're welcome