Forum Discussion
Solved
IF/AND Formula Not Working
I am trying to formulate a column that will return a DAYS formula result if multiple conditions are met, or a blank cell if they are not. Whatever I do, though, is returning a blank value. The f...
I miss nonblank checking. It'll be
=IF(AND([@[Puchasing Agent]] <>"",[@GL]=0),TODAY()-[@[P.O. Release]],"")
Thank you for replying. I just tried changing it per your suggestion, but it did not affect the return value.
I miss nonblank checking. It'll be
=IF(AND([@[Puchasing Agent]] <>"",[@GL]=0),TODAY()-[@[P.O. Release]],"")That worked perfectly. Thank you so much for your help!
Edg38426 , you are welcome, glad to help