Forum Discussion
Return non related value based on one, two or three cells
Cells A2:C2: are populated with text. How can I return a value to D2, that is determined by different combinations of A2:C2? Based only on whether or not A2:C2 values contain text or are empty. D2 wo...
=IF(AND(ISTEXT(A2),ISTEXT(B2),ISTEXT(C2)),"x",IF(AND(ISTEXT(A2),NOT(ISTEXT(B2)),ISTEXT(C2)),"y",IF(AND(NOT(ISTEXT(A2)),NOT(ISTEXT(B2)),ISTEXT(C2)),"z","")))
You can try a nested IF formula.
- Thank you! I will give it a go. Take care.