Forum Discussion
Solved
Use multiple IF functions in one cell without nesting
Hi All, I don't even know if this is possible but here's what I'm trying to do: I have an excel and in cells F, I, M, N and O have a formula that either puts a value or a "not eligible" phra...
=TEXTJOIN(", ",TRUE,IF(F7:O7="Not eligible",F$1:O$1,""))
=TEXTJOIN(", ",TRUE,IF(F7:O7="Not eligible",F$1:O$1,""))
=TEXTJOIN(", ",TRUE,IF(F7="Not eligible","QA",""),IF(I7="Not eligible","Tardies",""),IF(M7="Not eligible","Break & Lunch",""),IF(N7="Not eligible","Personal",""),IF(O7="Not eligible","Absences",""))
Was the answer. Thank you!
Was the answer. Thank you!