View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jollydottie jollydottie is offline
external usenet poster
 
Posts: 4
Default 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.