May 13 2022 07:04 AM
I'm using Excel 2016 does anyone know why the SWITCH function isn't available? Is there any other function I can use instead?
May 13 2022 07:29 AM
SWITCH is available in Excel 2019 and later.
You can use IFS instead. For example
=SWITCH(A1,1,"one",2,"two",3,"three","none")
can be replaced with
=IFS(A1=1,"one",A1=2,"two",A1=3,"three",TRUE,"none")
May 13 2022 07:43 AM
May 13 2022 07:46 AM
SolutionOops, 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.
May 13 2022 08:29 AM
May 13 2022 09:44 AM
May 19 2022 12:56 AM
yes it worked thank you so much for your help I really appreciate it @Hans Vogelaar
May 13 2022 07:46 AM
SolutionOops, 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.