Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|