How to return 1 with #VALUE!?
 

Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric

How to return 1 with #VALUE!?
 

One way:

=IF(ISERROR(<your formula), 1, <your formula)

In XL2007:

=IFERROR(<your formula,1)

However, it's generally bad practice to do so unless that error is
expected and not easily avoidable. Using either of the above formulae
will also mask other errors. One can usually identify the conditions
that would cause the error and prevent them.


In article ,
Eric wrote:

Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric

How to return 1 with #VALUE!?
 

You can use the function ERROR.TYPE to only check for #VALUEs:

=IF(ERROR.TYPE(<YourFormula)=3,1,<YourFormula)

Altho all the caveats made by JE McGimpsey re masking genuine errors
still apply - you'll just have excluded the other error types.

Hope this helps!

Richard


Eric wrote:
Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric