Can you convert this formula to 2003 from 2007? |
|
Author |
Message |
Anjaana
|
Posted: Mon Jul 09 06:43:30 CDT 2007 |
Top |
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
Excel491
|
|
|
|
|
Bob
|
Posted: Mon Jul 09 06:43:30 CDT 2007 |
Top |
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)
> 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
|
|
|
|
|
bj
|
Posted: Mon Jul 09 07:36:08 CDT 2007 |
Top |
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))
> 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)
>
> > 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
>
>
>
|
|
|
|
|
|
|