|Sat 20 Feb 16|
Business Functions works with Excel 2016 for Windows. BF does not work with Excel for Mac or Android because these platforms have never fully supported add-ins.
There is a new function in Excel 2016 called Switch which clashes with the BF of the same name! The argument lists are nearly compatibly but not quite. BF has the default value at the beginning whereas the Excel function puts it at the end. Therefore you have 2 options:
1. Convert your models to MS's switch function simply by rearranging the arguments.
2. As soon as we have renamed the BF function BFSwitch, you can simply edit your switch formulae with the new function name.