Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
Problem with empty cells when creating chart using vba | Charts and Charting in Excel | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) |