Forum Discussion
Solved
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.
I don't understand why you have changed the suggested formula.
The formula returns "Assigned" if the date is in the future. In the attached file the date in cell J5 is "19.05.2022" and the formula returns "Assigned" as intended. On the 19th of may 2022 the formula returns "in process" in cell A5. In cell J9 the date is "11.03.2022" and the formula returns "in process" in cell A9 as intended.
If you want these results you can simply implement the suggested formula.
In the dutch version it didn't, don't know why but after reentering it it works!!! thanks