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.

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

**Â **

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