Forum Discussion

Ctross's avatar
Ctross
Copper Contributor
May 02, 2026

Help with turning categorical variable to numerical

Hello, I have a statistical coding assignment and one of my tasks is to turn a bunch of different numerical variables into categorical. I have to use a logical function and it works perfectly when I ...
excel
Excel on Mac
Formulas and Functions
Olufemi7's avatar
Olufemi7
Steel Contributor
May 04, 2026

HelloCtross​,

Use an IF wrapper to return blank when the entire row has no data and simplify the logic with OR

=IF(COUNTA(A1:I1)=0,"",IF(OR(A1=1,B1=1,C1=1),"Curly",""))

This keeps the cell blank when A1:I1 is empty and avoids #N/A while returning Curly when any condition is met