problem of an empty cell
 

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

problem of an empty cell
 

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!!


"octet" wrote:

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

problem of an empty cell
 

Use

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

--


Regards,


Peo Sjoblom

"octet" wrote in message
...
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

problem of an empty cell
 

Thanks

"Pranav Vaidya" wrote:

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!!


"octet" wrote:

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

problem of an empty cell
 

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

"octet" wrote in message
...
Thanks

"Pranav Vaidya" wrote:

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!!


"octet" wrote:

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

problem of an empty cell
 

Try this:

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


"octet" wrote:

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