Division by zero in formulas yields 0.0


It should return plus or minus infinity, #ERROR, NaN or any other indication.


Hi there, what calculation did you use that yield the unexpected result of 0?

I tried to reproduce this problem with the calculation “1 / 0” and the output is the expected value of Infinity.


You were unable to reproduce this bug probably because it has been fixed.