Thread: How do I Calculate PI in an Excel formula?
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default How do I Calculate PI in an Excel formula?
On Jan 11, 12:02*pm, "Bernard Liengme"
wrote:
Then 4*ATAN(4) and PI() must give exactly the same answer
within the precision of Excel (15 decimals)

Yes. Both 4*ATAN(1) and PI() are represented in binary exactly as
3.14159265358979,311599796346854418516159057617187 5. (The comma marks
15 significant digits to the left.) At least, that is the case for
Excel 2003.
Reply With QuoteReply With Quote