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.

**Table of Contents**Expand

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

## 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**.

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

** **

- 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**