[Solved!] Name Error of PI Function in Excel

In this article, we will discuss the Name Error of the PI Function in Excel. The Name Error is a common error in Excel. There are many reasons to have that error, i.e., not writing the function properly, not closing the parenthesis, inappropriate range reference in the function etc. In this article, we will try to find out the reason behind the Name Error in PI function and resolve it.


Download Practice Workbook

You can download the practice workbook here.


What Is Name Error and Why Does Excel PI Function Name Error Occur?

The PI function is an argument less function. It gives the value of the pi up to 14 decimal places. However, sometimes the function returns #NAME?, like the one in the picture below. The Name Error occurs when Excel cannot find any resemblance to the preset functions with the function written by the user. For instance, Excel cannot recognize the PI without parenthesis in the picture below. That is why it is showing the Name Error. It could also happen if the user did not close the parentheses of the function.

pi in excel name error


Solution Process If Name Error of PI Function Occur in Excel

In this section, we will resolve the Name Error of the PI function in Excel. We will write the function properly to resolve the issue. Consequently, we will calculate the area of circles with different radiuses.

Steps:

  • To start with, click on the C5 cell and enter the following formula,
=PI()*B5^2
  • Then, hit Enter.

entering area formula to address pi function and name error in excel

Thus, we can see that the Name Error is no more there.

  • As a result, we will get the area of a circle with radius one.
  • Finally, lower the cursor down to the last cell to autofill.

Read More: How to Write Pi in Excel (5 Suitable Ways)


Using PI Function in Excel

Pi is a very significant constant in mathematics as well as engineering. It is used to calculate different parameters. The PI function returns nothing but the value of pi. So, it is used to calculate different parameters like area of circle, volume of a sphere etc.

1. Converting Degrees to Radians

Degrees and radians are two units of calculating angles. These units are fungible. In this instance, we will use the PI function to convert degrees to radians.

Steps:

  • Firstly, select the C5 cell and type,
=(B5*PI())/180
  • Then, press Enter.

 converting degree to radian to address pi function and name error in excel

  • As a result, we will get the radian value of the 30-degree angle.
  • Now, move the cursor down to autofill the rest of the cells.

Read More: How to Use PI(π) in Excel VBA (4 Easy Examples)


2. Calculating Volume

The formula of the volume of a sphere includes pi in it. So, we can use the PI function to replace the pi value. In this example, we will do that.

Steps:

  • To start with, select the C5 cell and enter the following formula,
=(4/3)*PI()*B5^3
  • Then, hit the Enter

  • Consequently, we will get the volume of a sphere with radius one.
  • Finally, move the cursor down to the last cell.

Read More: How to Put Pi by Using Formula in Excel (4 Suitable Examples)


Conclusion

In this article, we have resolved the Name Error of PI function in Excel. This is a common error in Excel. This article will allow users to solve the problem properly. If you have any questions regarding this essay, feel free to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website Exceldemy.Com and unlock a great resource for Excel-related content.


Related Articles

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo