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...

excel

Excel for web

Formulas and Functions

Detlef_Lewin
Aug 20, 2021
Roxana_Menendez
=TEXTJOIN(", ",TRUE,IF(F7:O7="Not eligible",F$1:O$1,""))

Detlef_Lewin

Silver Contributor

Aug 20, 2021

Roxana_Menendez

=TEXTJOIN(", ",TRUE,IF(F7:O7="Not eligible",F$1:O$1,""))

Roxana_Menendez
Copper Contributor
Aug 20, 2021
=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!
Roxana_Menendez
Copper Contributor
Aug 20, 2021
I'm receiving "An array value could not be found". Why F$1:O$1?
- Detlef_Lewin
  Silver Contributor
  Aug 20, 2021
  It could be any row. But did not share your workbook, so I made my assumptions.
  Or even hardcoded:
  {"QA"."".""."Tardies".""."".""."Break & Lunch"."Personal"."Absences"}

Forum Discussion

Use multiple IF functions in one cell without nesting

Resources