Formula update for earlier versions of Excel

[andrewb90]

Hello All,

I have a couple formulas that have been created in 2016 and I need to see if there are any ways to easily convert it to an older version. I have several variations of this formula, so any assistance making this change would be greatly appreciated!

=IF(Scheduler!E89<>"",Scheduler!E89,SWITCH(RO!C4,"1","TIME","2","OTHER","3","JURY","4","MATNY","5","AT AN","6",Initial!$C$46,""))

=SWITCH(G6,"TIME","","OTHER","","JURY","","MATNY","","AT AN","",Initial!$C$46,"","","","-")

=IF(Scheduler!F89<>"",IF(Scheduler!F89 = Initial!$E$31,"CLOSE",Scheduler!F89),SWITCH(RO!D4,"1","OFF","2","STORE","3","DUTY","4","LEAVE","5","EVENT","6",Initial!$D$46,""))

Many thanks!

 

[arthurbr]

This
SWITCH(RO!C4,"1","TIME","2","OTHER","3","JURY","4","MATNY","5","AT AN","6",Initial!$C$46)

Can be replaced with the CHOOSE function (be aware that "1" is text not a number)

=CHOOSE(RO!C4+0,"TIME","OTHER","JURY","MATNY","AT AN",Initial!$C$46)

or eventually with the LOOKUP function (vector form)

and this
=SWITCH(G6,"TIME","","OTHER","","JURY","","MATNY","","AT AN","",Initial!$C$46,"","","","-")

to = IF(OR(G6="TIME,G6="OTHER",etc...),"","-")