Divide by Zero

ejacksonBPT

How can I get a zero to show up so I can create a graph showing 0 of 36 locations are completed:

this is what is appearing in the cell

Jennifer Kurtz

Hi!

You could wrap your formula with the IFERROR function — e.g.,

=IFERROR([Column2]14/[Change Router Complete]16, 0)

that would return a '0' instead of the error message.

Jennifer Kurtz

Hi!

You could wrap your formula with the IFERROR function — e.g.,

=IFERROR([Column2]14/[Change Router Complete]16, 0)

that would return a '0' instead of the error message.