_xlfn prefix
in [Functions]
|
From: Bony Pony on 18 Feb 2010 06:20 Hi all, I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007. There are no workbooks open in compatibility mode anywhere. The workbook however does contain links to a 2003 workbook (currently closed.) In my Range name list, I have a range name _xlfn_IFERROR with a value of #NAME. I am using IFERROR functions embedded in the 2007 workbook not relating to "linked" cells. According to the Help file (Search for IFERROR then select the item Issue: An _xlfn prefix is displayed ...", it states "The Microsoft Office Excel Workbook contains a function that is not supported in the Version of Excel you are running." Fair enough. My question is - is the integrity of the IFERROR statement affected by the fact that there are links to a previous version of Excel? Can I still trust the result? Thanks for reading this. Regards, Bony -- "There are 10 types of people in this world. Those who understand Binary and those who don''t ..."
From: T. Valko on 18 Feb 2010 11:51 >Can I still trust the result? I don't know. However, when there might be version compatibility issues, why not use the equivalent IF(ISERROR which will work in any version of Excel? -- Biff Microsoft Excel MVP "Bony Pony" <bony_ponySPAMSPAM(a)BLOODYSPAMbtinternet.com> wrote in message news:264E018A-733D-4C40-BB24-4F5C8A73C968(a)microsoft.com... > Hi all, > > I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007. > There are no workbooks open in compatibility mode anywhere. The workbook > however does contain links to a 2003 workbook (currently closed.) > > In my Range name list, I have a range name _xlfn_IFERROR with a value of > #NAME. I am using IFERROR functions embedded in the 2007 workbook not > relating to "linked" cells. > > According to the Help file (Search for IFERROR then select the item Issue: > An _xlfn prefix is displayed ...", it states "The Microsoft Office Excel > Workbook contains a function that is not supported in the Version of Excel > you are running." Fair enough. > > My question is - is the integrity of the IFERROR statement affected by the > fact that there are links to a previous version of Excel? Can I still > trust > the result? > > Thanks for reading this. > > Regards, > Bony > > -- > "There are 10 types of people in this world. Those who understand Binary > and those who don''t ..."
|
Pages: 1 Prev: Multiple criteria search Next: find&select button, help? |