IF function help!

[nholagi]

Hi! I couldn't figure out how to write an IF function (or any function) that can show result like in the "outcome" column.

Basically if a row has 0 across then it should say "not in range", if there is a value in that row then return that column header name, if there are more than 2 value return then it should say "Multiple"
any thought?
thanks

 

[nholagi]

sorry everyone i guess i wasn't clear, can you explain the whole formula if possible?
esp why are you using just col "f" in here? i understand it give me the answer but i'm trying to read the whole formula ..if that make sense?

=LET(f,FILTER($A$1:$F$1,A2:F2=1,"Not in Range"),IF(COLUMNS(f)>1,"Multiple",f))

 

[Fluff]

The LET function allows you tore information in variables & f is just a variable. How to use the Excel LET function | Exceljet
The FUNCTION function returns all the values from A1:F1where A2:F2=1 How to use the Excel FILTER function | Exceljet