Get result that is the value (text) in one of 3 cells, with 3 conditions being combinations of 3 cells being blank or not blank. See image

Three separate formulas and output value: =IF(D7&E7="",C8) =IF((AND(C8&D8<>"", E8="")),D8) =IF(E9<>"",E9)

Image of conditions and table, separate formulas and table