#VALUE!
 

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.

#VALUE!
 

Try this in H3:

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

Or. more generally:

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

Hope this helps.

Pete

On Feb 1, 4:14*pm, sixthhole
wrote:
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.

#VALUE!
 

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" wrote:

Try this in H3:

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

Or. more generally:

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

Hope this helps.

Pete

On Feb 1, 4:14 pm, sixthhole
wrote:
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.

#VALUE!
 

Thanks for feeding back - glad to be of help.

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

Pete

On Feb 1, 4:51*pm, sixthhole
wrote:
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" wrote:
Try this in H3:

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

Or. more generally:

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

Hope this helps.

Pete

On Feb 1, 4:14 pm, sixthhole
wrote:
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.- Hide quoted text -

- Show quoted text -