If statement to get rid of errors (#DIV/0!)

[lcohenvb]

I can't remember how to write an if statement to put a 0 in a cell if it can't be divided by 0. The statement so far is:

=+(BK41-BL41)/BL41

All I want is either the result of the calculation or a 0 but of course, when the number can't be divided, I get #DIV/0!. Can anyone tell me the correct syntax for the if statement to avoid this.

Sorry, i know this is a simple question but I'm not a very sophisticated user.

Thanks for your help!

 

[Derek]

Hi there

You can try the IsError function:

If(IsError(your formula),0,your formula)

regards

Derek

 

[HalfAce]

Try this:
=IF(ISERR(+(BK41-BL41)/BL41),0,+(BK41-BL41)/BL41)
Dan
(Edit: I see Derek beat me to it...(again )

 

[lcohenvb]

I KNEW ya'll would know it right off! thank you both, it works perfectly!

 

[DRJ]

You don't really need iserror for this.

=If(BL41,(BK41-BL41)/BL41,0)


If(Denominator,Numerator/Denominator,0)

 

[tactps]

If you are only interested in DIV/0 errors, then a simple:

=if(BL41=0,0,(BK41-BL41)/BL41)

will do.

This will then highlight other errors.