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