Filtering out errors...
http://www.openofficetips.com/blog/archives/2004/11/basic_functions_5.html
On 2/9/06, Barrie Backhurst <[EMAIL PROTECTED]> wrote:
>
> On Thu, 2006-02-09 at 11:12 -0800, Eugénio Varejão wrote:
> > Hi!
> >
> > When I write the function bellow:
> >
> > =IF('file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.C91
> <>"";INDEX('
> file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.$C$6:$C$125;MATCH(D91;'file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.$D$6:$D$125;0))
> )
> >
> >
> > I get the result expected when the external spreadsheet have the value.
> > But when the value does not exist I get an annoying #N/A and the
> > subsequent operations give the result #N/A, as expected. How can I
> > change the #N/A for a 0 (Zero) or a blank cell?
> >
> > Thank you for your time a knowledge,
> >
> > EVarejão
>
> Add the IF and ISNA functions to your formula to substitute your desired
> result, should ISNA be TRUE
>
> Barrie
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
