Marhier
10-24-2017, 04:15 AM
Good afternoon, I hope you're all well.
At my work, half the users are on Excel 2013 and the other half are on Excel 2010.
On a spreadsheet I've created, I've used the following formula:
=IF(ISNUMBER(1/B10),B10*0.0622,IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))
This works fine for me on 2013, but when a 2010 user loads it up, the formula gets changed to:
=IF(ISNUMBER(1/B10),B10*0.0622,_xlfn.IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))
As I understand it, the _xlfn. error occurs when a particular formula isn't supported by a certain version of Excel?
I really thought this would be more of an issue with Excel versions pre 2007 and am surprised 2010 is giving me this error.
I was wondering if anyone can suggest how I change my formula to enable it to work on 2010, while still working in 2013?
All help is greatly appreciated, thank you.
Regards
Martin
At my work, half the users are on Excel 2013 and the other half are on Excel 2010.
On a spreadsheet I've created, I've used the following formula:
=IF(ISNUMBER(1/B10),B10*0.0622,IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))
This works fine for me on 2013, but when a 2010 user loads it up, the formula gets changed to:
=IF(ISNUMBER(1/B10),B10*0.0622,_xlfn.IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))
As I understand it, the _xlfn. error occurs when a particular formula isn't supported by a certain version of Excel?
I really thought this would be more of an issue with Excel versions pre 2007 and am surprised 2010 is giving me this error.
I was wondering if anyone can suggest how I change my formula to enable it to work on 2010, while still working in 2013?
All help is greatly appreciated, thank you.
Regards
Martin