Forum Discussion
hicke097
Apr 16, 2021Copper Contributor
Ignore formula function in blank cells
My formula is =IF(OR(J4= "Yes", K4="yes", L4="Yes", M4="Yes"),"Eligibile","Not Eligible") Essentially, if there is at least one "yes' in any of the 4 cells, the next column will read "eligible." ...
Detlef_Lewin
Apr 16, 2021Silver Contributor