Forum Discussion
Jliersenvlst
Apr 19, 2022Copper Contributor
Help with an excel formula
Hello, I am writing a formula for table from column A to Column U. (In the dutch version so I translated the formula from dutch to english). The Formula is located in A4 Column A is called...
- Apr 19, 2022
=IF(T4=TRUE,"canceled",IF(R4=TRUE,"complete",IF(L4=TRUE,"process finished",IF(AND(J4<>"",J4<=TODAY()),"in process",IF(AND(J4<>"",J4>TODAY()),"assigned",IF(J4="","not assigned",""))))))
You can try this formula which seems to work in my sheet if i correctly understand what you want to do.
Riny_van_Eekelen
Platinum Contributor
Jliersenvlst You include a part ALS(J4=NU........
When the IF statements evaluate this part it breaks as NU is not recognized. So enter "NU" if you want to test for the word NU or, in case you intend to use the NU function, use NU() (NOW() in English).
But perhaps VANDAAG() (TODAY() in English) will have a better result.
Jliersenvlst
Apr 19, 2022Copper Contributor
Riny_van_Eekelen I tried both the NOW() and the TODAY() both doesn't seem to work. The formula works fine after putting a date in, after that it doesn't work anymore. When i check the boxes nothing is happening. 😞