Forum Discussion

GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
Jul 06, 2026

Can anyone help me with this SWITCH function

Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE,     IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0),     I...
developer
excel
Formulas and Functions
office 365
SelinaKnow's avatar
SelinaKnow
Brass Contributor
Jul 07, 2026

The issue is that SWITCH(TRUE, ...) expects logical conditions, but your formula is passing the results of IF() instead. Replace each IF(...) with the corresponding AND(...) condition (or use IFS()), and the formula will return the expected values instead of always falling back to 50.