Forum Discussion
Solved
Help
Can someone help me with this fct =IF(ISBLANK(I2);"");IF((I2>TODAY());"To anticipate";"Gate finished");IF((I2<EDATE(TODAY();1));"Priority") , i can t find the error , i get Value! error
Some brackets are in the wrong places. Perhaps this way:
=IF(ISBLANK(I2);"";IF(I2>TODAY();"To anticipate";IF(I2<EDATE(TODAY();1);"Priority";"Gate finished")))
Some brackets are in the wrong places. Perhaps this way:
=IF(ISBLANK(I2);"";IF(I2>TODAY();"To anticipate";IF(I2<EDATE(TODAY();1);"Priority";"Gate finished")))
Thank you! 😉