Zero point zero out to 14 decimal places is not 0? Pi()/90*90=Pi(); but Pi()/90+Pi()/90+PI()/90...90 times does not equal Pi()???

[Excelerate2014]

So how can it be that Excel calculates Pi()/90*90=Pi(); but Pi()/90+Pi()/90+Pi()/90......90 times is 0.000000000000033527. And why is the number zero out to 14 decimal places not being returned as 0?

I need to know exactly when a series of sequentially increasing radians = Pi(). The length of the series is dynamic and can be as few as 6 and as many as 120. And right now Excel is not cooperating.

Here is what excel thinks Pi()/90+Pi()/90+....90 times =

3.14159265358980000000

3.14159265358979000000 (this is how excel displays Pi() out to 20 decimal places)

So Excel thinks the two numbers are not equal to each other, and what could be more interesting is that Excel thinks the difference is

0.00000000000000355271

Even after copying and pasting both numbers as values out to 20 decimals. Excel still thinks the difference is 0.00000000000000355271

How is that possible?

I have Excel 2013. Is there some sort of bug here? I had posted earlier about major headaches when using natural log. Random cells keep getting forced to 14, 15, sometimes 16 or 17 decimals. No rhyme no reason. I can custom format every cell in worksheet to 2 decimals, and as soon as I hit F9... ############# all over the place. At least with Pi() the decimals are under control, but the math is not right. Pi()/x + Pi()/x.....x times = Pi().

 

[jasonb75]

Have a look at this thread, posts #6 and #7 http://www.mrexcel.com/forum/excel-questions/791048-weird-decimal-problem.html

and also the link I provided in post #4 of that thread.

 

[Excelerate2014]

Ok. That helps explain the Pi() issue. Much appreciated.