| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you convert this formula to 2003 from 2007?
Hi
I received a 2007 workbook with this formula =CONCATENATE(_xlfn.IFERROR(M2,"")," / ",_xlfn.IFERROR(P2,"")," / ",_xlfn.IFERROR(Q2,"")) (this is after it is opened in office 2003) - could you tell me the 2003 equivalent please? Thanks Sarah xx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you convert this formula to 2003 from 2007?
No idea what _xlfn is, but the IFERROR can be resolved like so
=CONCATENATE(_xlfn.IF(ISERROR(M2),"",M2)," / ",_xlfn.IF(ISERROR(P2),"",P2)," / ",_xlfn.IF(ISERROR(Q2),"",Q2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sarah_Lecturer" wrote in message ... Hi I received a 2007 workbook with this formula =CONCATENATE(_xlfn.IFERROR(M2,"")," / ",_xlfn.IFERROR(P2,"")," / ",_xlfn.IFERROR(Q2,"")) (this is after it is opened in office 2003) - could you tell me the 2003 equivalent please? Thanks Sarah xx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you convert this formula to 2003 from 2007?
the "_xlfn." indicates that the function is not supported in your version of
excel. probably Bob's fuction with the "_xlfn. "s removed is what you need. =CONCATENATE(IF(ISERROR(M2),"",M2)," / ",IF(ISERROR(P2),"",P2)," / ",IF(ISERROR(Q2),"",Q2)) "Bob Phillips" wrote: No idea what _xlfn is, but the IFERROR can be resolved like so =CONCATENATE(_xlfn.IF(ISERROR(M2),"",M2)," / ",_xlfn.IF(ISERROR(P2),"",P2)," / ",_xlfn.IF(ISERROR(Q2),"",Q2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sarah_Lecturer" wrote in message ... Hi I received a 2007 workbook with this formula =CONCATENATE(_xlfn.IFERROR(M2,"")," / ",_xlfn.IFERROR(P2,"")," / ",_xlfn.IFERROR(Q2,"")) (this is after it is opened in office 2003) - could you tell me the 2003 equivalent please? Thanks Sarah xx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert Excell 2007 file back to 2003 | Excel Discussion (Misc queries) | |||
| how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
| Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
| converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
| Can I just convert to Word 2003 and Excel 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
