andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
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!
Many thanks!
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!
Code:
=IF(Scheduler!E89<>"",Scheduler!E89,SWITCH(RO!C4,"1","TIME","2","OTHER","3","JURY","4","MATNY","5","AT AN","6",Initial!$C$46,""))
Code:
=SWITCH(G6,"TIME","","OTHER","","JURY","","MATNY","","AT AN","",Initial!$C$46,"","","","-")
Code:
=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!