Forum Discussion

Copper Contributor

May 13, 2022

Solved

SWITCH function

I'm using Excel 2016 does anyone know why the SWITCH function isn't available? Is there any other function I can use instead?

Copper Contributor

May 13, 2022

What can I replace SWITCH and IFS with to make this formula work?
=IF(type<>"",SWITCH(type,"W",1,"SW",2,"T",3,"M",4),-1

If I

MVP

May 13, 2022

Oops, sorry.

=IF(type="","",IF(type="W",1,IF(type="SW",2,IF(type="T",3,IF(type="M",4,-1)))))

Or use a LOOKUP or VLOOKUP formula.