Thank you for your service.
I would like to display the date when the value entered in the input field fildname3 is between 60 and 90, and also when fildname12==150 is selected.
//
IF(AND(fieldname3 <= 60 , fieldname12==1),cdate(fieldname21+4,’yyyy年mm月dd日’),
IF(AND(60 < fieldname3 && fieldname3 <= 90),cdate(fieldname21+5,’yyyy年mm月dd日’),
IF(AND(90 < fieldname3 &&fieldname3 <= 120),cdate(fieldname21+6,’yyyy年mm月dd日’),
IF(AND(120 < fieldname3 &&fieldname3 <= 150),cdate(fieldname21+7,’yyyy年mm月dd日’),
IF(AND(150 < fieldname3 && fieldname3 <= 180),cdate(fieldname21+8,’yyyy年mm月dd日’),
IF(AND(180 < fieldname3,fieldname12 == 1),cdate(fieldname21+9,’yyyy年mm月dd日’),
IF(AND(fieldname3 <= 60 , fieldname12==150),cdate(fieldname21+2,’yyyy年mm月dd日’),
IF(AND(60 < fieldname3 && fieldname3 <= 90 , fieldname12==150),cdate(fieldname21+3,’yyyy年mm月dd日’),
IF(AND(90 < fieldname3 && fieldname3 <= 120,fieldname5 == 150),cdate(fieldname21+4,’yyyy年mm月dd日’),
IF(AND(120 < fieldname3 && fieldname3 <= 150,fieldname5 == 150),cdate(fieldname21+5,’yyyy年mm月dd日’),
IF(AND(150 < fieldname3 && fieldname3 <= 180,fieldname5 == 150),cdate(fieldname21+6,’yyyy年mm月dd日’),)))))))))))
IF(AND(60 < fieldname3 && fieldname3 <= 90 , fieldname12==150),cdate(fieldname21+3,’yyyy年mm月dd日’),
↑
It will not function from this text.
What should I do?
Sorry for the poor writing.
The page I need help with: [log in to see the link]