The good news is that Excel knows the pi number to its 15th digit by heart.
The PI Function in Excel: How Does It Work?
PI is a simple Excel function that returns the pi number with 14 decimals.
Screenshot by Amir M. Bohlooli. No attribution required.
It only does that and takes in no arguments.
If used alone in a formula, PI simply returns the pi number.
Since PI takes in no arguments, Excel treats it more like a numerical value rather than a function.
This means that you could simply call PI in your formula, and then perform mathematical operations on it.
Let’s see this in action with an example.
You should now see the diameter for each circle.
This comes in extra handy when you’re using trigonometric functions in Excel.
Pi radians is one radian multiplied by pi.
For this task, we’re going to use a combination of the PI function and the DEGREES function.
DEGREES is an Excel function that takes in radian values, and converts them to degrees.
You canuse the CONVERT function in Excel to convert other units.
Forget About Pi’s Actual Value
The pi number is one of the most important mathematical constants.
Screenshot by Amir M. Bohlooli. No attribution required.
As far as modern computing capabilities go, pi has an infinite number of decimals.
The PI function in Excel returns the pi number up to its 15th digit.
