How do I Calculate PI in an Excel formula?
on Excell
=E15+14.86*D15*PI()*F15*0.85 =139.0444
on my calc
=20 + 14.86 = 34.86 x 6 = 209.16 x PI = 14.462 x .500 = 7.23 x .85
= 6.1465- this is the right answer
So what am I doing wrong?
"Gary''s Student" wrote:
In an empty cell, enter:
=PI() and format the cell to display 15 places to see:
3.141592653589790
This is the approximation Excel uses for pi.
--
Gary''s Student - gsnu200825
"jollydottie" wrote:
Using the calculator I get a different answer, if PI = 3.162. then *3.162 in
Excell should give me the right answer but it doesn't.
|