Frank Bacchus
Member
Hi all:
Below is a formula consisting of two conditions which are:
(1) If the value in L2 AND the value in M2 are both blanks, then set the value of the current cell to "No TRD, TPR, HIF" (this works by itself)
(2) If the value in A2 OR the value in B2 is NOT blank, then set the value of the current cell to "TRD, TPR" else set the current cell to “Investigate”.
Formula:
=IF(AND(L2="", M2=""),"No TRD, TPR, HIF"), IF(NOT(OR(A2 ="", B2 ="")),"TRD, TPR"," Investigate")
I get a #VALUE when both A2 and B2 are “”
Your feedback would be much appreciated. Thanks
Frank
Below is a formula consisting of two conditions which are:
(1) If the value in L2 AND the value in M2 are both blanks, then set the value of the current cell to "No TRD, TPR, HIF" (this works by itself)
(2) If the value in A2 OR the value in B2 is NOT blank, then set the value of the current cell to "TRD, TPR" else set the current cell to “Investigate”.
Formula:
=IF(AND(L2="", M2=""),"No TRD, TPR, HIF"), IF(NOT(OR(A2 ="", B2 ="")),"TRD, TPR"," Investigate")
I get a #VALUE when both A2 and B2 are “”
Your feedback would be much appreciated. Thanks
Frank