IfError

[tiredofit]

In column A, I have these values:

1
#N/A
#N/A
0
5

In column B, I type:

=IF(A2=0,"Zero",IFERROR(A2,"Zero"))

I expected for those rows that contain an error to return "Zero" but it returns #N/A.

Why is that?

Thanks

 

[steve the fish]

You could do it like this but you have nothing for if A2 is not equal to 0 or an error:

=IFERROR(IF(A2=0,"Zero",""),"Zero")

 

[Nine Zero]

are the values in column A ... formulas? values you typed in?

because the way you have it now, this might work

=IF(OR(A2=0,A2="#N/A"),"Zero","")

 

[tiredofit]

Thanks for the suggestion.

The values in column A are NOT formulae.

 

[Nine Zero]

Yeah if you type #N/A Excel reads that as text. It doesn't know (at least to my knowledge) that you are meaning "error" by typing that in there. So in order to handle a situation where you type it in like the current one, you need to handle it as if you typed text in there. So the formula i mentioned above should work.