Forum Discussion

Copper Contributor

Jul 30, 2020

Solved

Exel, division by 0

Sorry, my native language is Russian. This message was sent to Microsoft Technical Support. I was directed here to ask a question about my mistake. I am using Microsoft Exel 2010, composing the for...

excel

Formulas and Functions

HansVogelaar
Jul 30, 2020
Woory

This is caused by tiny rounding errors that occur when converting from decimal to binary and back.

The formula =1-((0.052*225)/(0.9+0.048*225))=0 returns FALSE, and the formula =1-((0.052*225)/(0.9+0.048*225))-0 returns 0.000000000000000111022302462516.

Since the numbers in your formula are accurate to 3 decimal places, you can avoid the problem by rounding the denominator to 3 decimal places:

=A1/ROUND(1-((0.052*225)/(0.9+0.048*225)),3)

HansVogelaar

MVP

Jul 30, 2020

Woory

This is caused by tiny rounding errors that occur when converting from decimal to binary and back.

The formula =1-((0.052*225)/(0.9+0.048*225))=0 returns FALSE, and the formula =1-((0.052*225)/(0.9+0.048*225))-0 returns 0.000000000000000111022302462516.

Since the numbers in your formula are accurate to 3 decimal places, you can avoid the problem by rounding the denominator to 3 decimal places:

=A1/ROUND(1-((0.052*225)/(0.9+0.048*225)),3)