|
Answer» Hey Friend....☺
Here is your answer
Dividing by Zero in Excel
Without getting into a semantics debate, Excel does allow you to divide by zero. It also lets you know you have an error. In the resulting cell, it shows the famous line of #DIV/0!. It’s one of those error messages where the LETTERS and numbers make sense, but you also wonder if your PC is swearing at you.
Although your PC isn’t mad, the message may fluster users. Some look at the alert and see the help text “The formula or function used is dividing by zero or empty cells” as shown below. Others might question the data integrity. Personally, I THINK it’s an aesthetic issue.
The reason I got this Excel error was that I tried to divide my Cost VALUE in C7 by my Catalog Count in D7. This TEST ad cost $77.45 and GENERATED 0 catalog requests. A similar error occurs if the Catalog Count cell was blank.
Hoping it helps
Thanks :-)
|
