problem of an empty cell

[octet]

i have an empty cell B14 that says #DIV/0!
does anyone know why this formula i recieve an error try to use this fuction?
=IF(AND(B14<>"",B14<>0),C14-B14)/B14,"")

Thanks
Octet

 

[Pranav Vaidya]

You are getting this error because you are trying to divide the value by
zero. Either your cell b14 is empty or contains 0. To avoid this from showing
you can make use of ISERROR function.

HTH,

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!

 

[Peo Sjoblom]

Use

=IF(B14=0,0,(C14-B14)/B14)

--


Regards,


Peo Sjoblom

 

[octet]

Thanks

You are getting this error because you are trying to divide the value by
zero. Either your cell b14 is empty or contains 0. To avoid this from showing
you can make use of ISERROR function.

HTH,

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will help
others!!

 

[Peo Sjoblom]

I'd suggest you avoid the ISERROR solution in this case since it will hide
errors you might want to know about.
All you have to do to avoid the divide by zero is to test the divisor cell
in your case B14 and make sure it is not zero

=IF(divisor=0,do_this,division_formula)


however if you have another error in the dividend like a value error than
most likely you would like
to know that so you can correct it. However if you use ISERROR it will hide
that error.
It's like swatting flies with an umbrella


--


Regards,


Peo Sjoblom

 

[Teethless mama]

Try this:

=IF(N(B14),(C14-B14)/B14,"")