What would be really nice would be a set of functions that duplicate the IS*() error functions but provide a second parameter, which is the value to use if there is an error. I.e. ONERROR(value ; error_value). This would save having to calculate 'value' twice [often with a very long formula like this]: once for the test and again for the value. The other option is to use a work area cell that holds the intermediate value.
Or is that already do-able in some obvious way that I just haven't seen? On Thu, 2006-02-09 at 21:54 -0600, David Chapman wrote: > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
