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

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

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