View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I Calculate PI in an Excel formula?

The value of Pi approximates 3.142 not 3.162,
A more exact value is
3.141592653589793238462643383279502884197169399375 10582097494459230781640628620899862803482534211706 79
To see more digits visit
http://www.eveandersson.com/pi/digits/1000000

Excel gives Pi to 15 decimal places using =PI()

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jollydottie" wrote in message
...
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.