C# & Excel Result does not match

[Shahid Bhatti]

I am stuck in a strange situation.

In Microsoft Excel, I have written followingv formula

=(1+0.165833333333333000)^-18

And its result is 0.97061510780437700

While same equation in .Net

System.Math.Pow(Convert.toDouble(1+0.165833333333333000), -18) gives following result:-

0.97061510780437643

Difference b/w both result start on 15th decimal places.


Please help how to sort this out.

Continue reading...