Trying to make a cell (H79) return a value of "X" (literally just an X), if g61:g67, g70:g76, g79:g85, g88:g99, g102:g106, is three (FAC, FACW, and/or OBL) of these 5 options (OBL, FACW, FAC, FACU, UPL).
Would the formula be, =IF($G61:G67:$G70:G76:$G79:G85:$G88:G99:$G102:G106="FAC""FACW""OBL","X","")
It's not working, and I don't know where my error is.
Would the formula be, =IF($G61:G67:$G70:G76:$G79:G85:$G88:G99:$G102:G106="FAC""FACW""OBL","X","")
It's not working, and I don't know where my error is.