View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default How do I Calculate PI in an Excel formula?

Want to inform us, seeing as we took the time to try and help?

--
__________________________________
HTH

Bob

"jollydottie" wrote in message
...
Thank you all, I have found my error.

"Ron Rosenfeld" wrote:

On Sun, 11 Jan 2009 11:34:01 -0800, jollydottie
wrote:

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?


1. If by PI you mean the ratio of the circumference to the diameter of a
circle, then your calculated result is incorrect as the value of PI is a
bit
more than 3 and no way can 209.16 x PI be less than 627. Your calculator
seems
to be giving you a result of 14.462, if I understand what you have
written
above.

2. In addition to that, you are probably not understanding the order in
which
Excel performs operations in formulas, which is documented in HELP.

You can use parentheses to control the calculation order, so your Excel
formula
might read:

=(E15+14.86)*D15*PI()*F15*0.85

But you still have your calculator doing:

209.16 * PI -- 14.462 which, since PI = 3.14159..., is incorrect.
--ron