Excel PI Function: The term PI (π) is a mathematical constant value. During our school days, we use many formulas with the PI value in Math and Physics. The approximate value of PI is 3.14159. This PI value is derived from the ratio of a circle’s circumference to its diameter. In decimal form, we can mention its value as 3.14.
As we all know, Excel has more number of built-in functions and formulas, it also includes the PI function. If you want to use this function on your Excel workbook, then keep reading this page. We will offer you clear-cut instructions to know how to use the PI function on your Excel workbook with its brief explanations, syntax, and examples. Get an official version of MS Excel from the following link
PI Function – Description
- This function returns the value of the constant π (3.14159265358979).
- As we already said, the value of PI is calculated by dividing a circumference of a circle by its diameter.
- You need to know that, Excel stores the value of PI accurately to 15 digits and up to 14 decimal places (3.14159265358979), so we can get more accurate results when we use it in Excel.
- This is the syntax of the PI function in Excel. To get the PI value on your spreadsheet, just copy and paste the below-given formula on any cell, and press the Enter button.
- At the instance, you will get the PI value on the selected cell.
- This function cannot have any arguments.
Note: If any argument is a non-numeric value (letters and special characters) and then it returns #VALUE! Error.
Here, we come up with some examples to try out this PI function on the Excel worksheet. The given examples might be enough for you to understand the working concept of the PI function.
- Initially, you have to open your Excel workbook on your PC and launch a new worksheet.
- If you want to get the PI value on the active cell, then you need to use the PI function.
- Once you enter the formula in the selected cell, click on the Enter button to get the result, as shown below.
Let’s see another example to know how to use the PI function with operators. For instance, we try to divide and multiply certain values with PI.
- To do so, you need to enter the formulas as shown in the following screenshot.
- You can see that we have calculated the value of π\2, π\5, and π*2.
So far, we have learned how to use Excel PI Function with its syntax, description, and examples. We hope that the provided example might be helpful to you.
If you have any queries regarding this Excel PI function, kindly comment to us in the below section. If you want to learn more Excel formulas, then visit our webpage Aawexcel.com.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!