View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default How do I Calculate PI in an Excel formula?

While Excel will only display 15 digits, its value for pi is correct to
almost 17 digits. To 17 digits, Excel's value for pi is
3.1415926535897931
compared to the actual 17 digit approximation to pi of
3.1415926535897932

Jerry

"Shane Devenshire" wrote:

....
PI has been calculated to 2 billion digits, probably more by now, but Excel
is not prepared for more than 15.

....