Probably a stupid question and If I had time....

[WillM]

I'd seach around the board as someone is BOUND to have asked before but....

How do you get rid of a "#DIV/0!" ??

Thanks in advance !

Will M

 

[al_b_cnu]

HI,

either

1) dont divide by zero

or
2) if iserror(formula),0,formula


HTH

Alan

 

[just_jon]

Got a formula in particular that you're talking about, or in general?

 

[WillM]

Thanks very much.Worked a treat.

Will M

 

[Ekim]

A2: 5
B2: 0 (zero) or blank

Normally, 5 divided by 0 or 5 divided by a blank cell will return the "#DIV/0!" error.

One solution:
=IF(OR(B2 = 0,B2 = ""),"",A2/B2)

HTH

Mike

 

[Brian from Maui]

=IF(B1,A1/B1,"")