Computing variables with If-Then

[nebojsa]

Sorry for the copy paste mistake "aJnd". This is the correct formula. It is still the same problem:
IF(YEAR==1 and L_CL_CR_R==1, 1, IF(YEAR==3 and L_CL_CR_R==1, 2, IF(YEAR==1 and L_CL_CR_R==2, 3, IF(YEAR==3 and L_CL_CR_R==2, 4, IF(YEAR==1 and L_CL_CR_R==3, 5, IF(YEAR==3 and L_CL_CR_R==3, 6, IF(YEAR==1 and L_CL_CR_R==4, 7, IF(YEAR==3 and L_CL_CR_R==4, 8, 0))

[jonathon]

hi,

please start a new topic next time ... this is an old thread.

you have a lot of opening brackets, but very few closing ones.

jonathon

[nebojsa]

Yes, the problem with brackets came to my mind as well. I tried to close all 8, but it didn't work. Maybe I'm missing something?