Forum Discussion
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?
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.
IFS also isn't available on this version of excel?
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
=IF(type<>"",SWITCH(type,"W",1,"SW",2,"T",3,"M",4),-1
If I
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.
- This also didn't work. It said there are too many arguments? I'm really struggling 😞
Could this be because the cells already have complicated conditional formatting arguments already? I'm following a guide but without SWITCH or an equivalent all my hours of work will be useless