Forum Discussion
nested IF and AND statement
Hello, I need assistance figuring out a formula for a table. its a bit complex. I need cell AE1 to calculate the lowest date between cells AB1 (Symptom onset date) and either cells M1, P1, S1, V1,...
From your PM I understand you want
=LET(d,DATE(9999,12,31),MIN(IF(AB1<>"",AB1,d),IF(O1="Positive",M1,d),IF(R1="Positive",P1,d),IF(U1="Positive",S1,d),IF(X1="Positive",V1,d)))