PDA

View Full Version : [SOLVED] Formula Support Issue



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

Marhier
10-24-2017, 04:20 AM
Ok... I think I solved it, lol.
I've changed it to:


=IF(ISNUMBER(1/B10),B10*0.0622,IFERROR(VLOOKUP(C10,Obex_Price_List,3,0),""))

Seems to have done the trick...

mancubus
10-24-2017, 04:27 AM
As I understand it, the _xlfn. error occurs when a particular formula isn't supported by a certain version of Excel?

that's correct.

and IFERROR was the answer as you figured out.