[Solved!] Name Error of PI Function in Excel

Get FREE Advanced Excel Exercises with Solutions!

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 for 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.


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


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 the area of the circle, the 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 


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 a radius of one.
  • Finally, move the cursor down to the last cell.

Read More: How to Multiply Pi in Excel


Download Practice Workbook

You can download the practice workbook here.


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.


<< Go Back to Excel PI Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Adnan Masruf
Adnan Masruf

Adnan Masruf, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. His deep passion for research and innovation seamlessly aligns with his dedication to Excel. In this capacity, Masruf not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, underscoring his steadfast commitment to consistently delivering exceptional content. His interests... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo