How accurate is Pi in Excel and is it enough?


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Does Excel have enough significant digits for Pi in the inbuilt Pi() function?

Modern computing can calculate Pi to 3.14 trillion digits which is a good trick but even extreme situations only needs Pi to 15 significant digits.

What’s extreme?  How about interplanetary travel?  JPL/NASA calculate the paths of probes to Mercury, Mars, Jupiter and beyond.  They ‘only’ need 15 significant digits or 3.141592653589793 .

As Marc Rayman from NASA explains, working out distances on Earth using Pi to 15 places gives accuracy less than your average molecule’s width.

As part of a misspent youth, our Editor-in-Chief Peter Deegan memorized Pi to twenty decimal places – double the number someone bet he couldn’t do.  That’s nothing compared to people who can recite Pi to a hundred or more digits.

PI() accuracy in Excel

Excel’s PI() function returns 14 decimal places or 3.14159265358979

how accurate is pi in excel and is it enough microsoft excel 26855 - How accurate is Pi in Excel and is it enough?

It’s the maximum precision possible in Excel (15 digits in total)

That’s the same in Excel for Windows, Mac, Apple and Android – as it should be.

14 decimal places should be enough for almost any Excel user.

Less accurate PI()

If you don’t need all 14 decimal places for PI, the Round() function will adjust to the lower accuracy you need e.g.  =ROUND(PI(),5) will return Pi rounded to 5 decimals.

how accurate is pi in excel and is it enough microsoft excel 26856 - How accurate is Pi in Excel and is it enough?

subs profile e1563205311409 - How accurate is Pi in Excel and is it enough?
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address