#VALUE!

[sixthhole]

Using multiple lookups in multiple arrays. I'm going to get #VALUE! returns
at times. How can I convert to 0 (zero)?

Ex: cell G3 returns #VALUE! and I'd like to convert that to 0 in cell H3.

 

[Pete_UK]

Try this in H3:

=IF(ISERROR(G3),0,G3)

Or. more generally:

=IF(ISERROR(your_formula),0,your_formula)

Hope this helps.

Pete

 

[sixthhole]

Pete_UK -- Thank you! Simple, elegant and a multitasker. I've replaced
=IF(ISNA) with this function and eliminated a lot of extraneous cells.

 

[Pete_UK]

Thanks for feeding back - glad to be of help.

ISNA detects #N/A errors only, whereas ISERROR detects them all.

Pete