This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello-
I am using a basic formula (numerator/denominator) to calculate a result. So when someone has had zero inspections they would enter 0 in both columns. And I need the 0 to appear in the results, not a #DIV/0.
The reason I cannot use the IFERROR function to solve the #DIV/0 problem is because there are some cells in the numerator/denominator columns that stay blank and need to stay blank. Using the IFERROR function changes these columns to "0" as well.
Is there a way to differentiate a zero and a blank?
Thanks!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
See the screen capture below. Formulas used in column C are displayed in column D.
Answer accepted by question author
The ISNUMBER() function can differentiate a zero and a blank.
For example, something like this might help:
=IF(AND(ISNUMBER(B1), ISNUMBER(A1), B1=0, A1=0), 0,IF(LEN(A1&B1)=0,"",A1/B1))
This is the function to use. Thank you!
Great!Thank yoy!