ISERROR formula

[ron.bo]

I have a simple formula problem, but I am stuck. I need a formula to return "", if the cell is an error (#DIV0!) or 0. If not return the value.

Thanks,
Ronbo

 

[qwerty_99]

I think that could work:

=IFERROR(IF(A2=0;"";A2);"")

 

[ron.bo]

Thanks, but I get and error on it

 

[qwerty_99]

Works for me:

[/URL][/IMG]


Sorry my excel is not in english.

 

[qwerty_99]

OOOOOhhh, maybe you're using ISERROR instead of IFERROR.

ISERROR is Boolean, will only tell you if it is an error or not. IFERROR allows you to do something else if it is an error.

 

[ron.bo]

That is strange. I do the exact example and mine bombs on the 0 of A2=0.

 

[qwerty_99]

Really strange...

Maybe =IF(ISERROR(C2);"";IF(C2=0;"";C2)) could work?

Edit: You could try IF ISNUMBER AND <> 0 as well...

 

[ron.bo]

I am using IFERROR as well as IF,IF,AND,OR,ISERROR etc. I can get a lot of combinations to work with <0 but not with #DIV0!. Here is my last try which works but not with #DIV0!... =IF(OR(CB41<0,ISERROR(CB41)),"",CB41)

 

[ron.bo]

The last formula also results in and error. All I need to do is combine two formulas, =IFERROR(BO24,"") + =IF(BO24<0,"",BO24)

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C	D
1	6	0	#DIV/0!
2	0	4	0
3	6	2	3	3
Sheet