_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.