Forum Discussion
_xlfn. result on different machines
Hi All,
Looking for some advice, we have developed a .xlsm document to calculate pricing for an industrial business.
The author and reviewer have completed testing on two seperate machines running Excel 2016 64bit, we have also tested on Excel 2016 32bit.
When opening the document all cells work but when he operator changes any editable cell a #Name? returns in some cells.
The formula is
=IFS(AK6>1180.1,'Lookup Calculators'!$M$60,AK6>1030.1,'Lookup Calculators'!$L$60,AK6=0,0,AK6>880.1,'Lookup Calculators'!$K$60,AK6>730.1,'Lookup Calculators'!$J$60,AK6>580.1,'Lookup Calculators'!$I$60,AK6>480.1,'Lookup Calculators'!$H$60,AK6<=480,'Lookup Calculators'!$G$60)*C6
When running on other machines the formula returns
=_xlfn.IFS(AK6>1180.1,'Lookup Calculators'!$M$60,AK6>1030.1,'Lookup Calculators'!$L$60,AK6=0,0,AK6>880.1,'Lookup Calculators'!$K$60,AK6>730.1,'Lookup Calculators'!$J$60,AK6>580.1,'Lookup Calculators'!$I$60,AK6>480.1,'Lookup Calculators'!$H$60,AK6<=480,'Lookup Calculators'!$G$60)*C6
It seems that some versions do not run some formula which i understand which is confusing me is that the error is now returning on all machines but the Authors.
Perhaps a smarter formula would resolve the issue but this is beyond my excel capability at present. Help please.
The IFS function is only available if you have an Office 365 Subscription.
Tested by creating workbook in Excel Office 365 then opening in Excel 2010 to replicate the error described. Unable to test on a stand-alone Excel 2016 but would expect the same result.
