Forum Discussion
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...
=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.
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.
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. 😞
