How to use Pi in Google Sheets

In mathematics, π (pi) is a mathematical constant that represents the ratio of the circumference of a circle to its diameter. It is an irrational number, which means it cannot be expressed as a simple fraction and its decimal representation goes on forever without repeating. The value of π is approximately 3.14159, but it is often approximated as 3.14 for simplicity in calculations. In Excel, there is a specific function of Pi to calculate values.

In this Excel tutorial, we will explore the functionality of the “PI” function, which allows us to calculate the circumference of a circle. Additionally, we will discover how to insert the π (pi) symbol as text within cells. By mastering these techniques, you will gain valuable skills in utilizing mathematical constants and enhancing your Excel spreadsheets with precise calculations and visual representations.

Case 1 – Using the “PI” Function to calculate the circumference

Understanding Function and its Syntax

The “PI” function in Excel is a built-in mathematical function that returns the value of π (pi), which is approximately 3.14159. 

The syntax of the “PI” function is as follows:

=PI()

The function does not require any arguments or parameters, so you simply use the function name followed by opening and closing parentheses. When the function is used in a cell, it will automatically return the value of π. This value can then be used in mathematical calculations within Excel, such as calculating the circumference or area of a circle.

Step 1 – Select the cell

  • Select any empty cell in which you wish to find the circumference of the circle
  • We will use the “PI” Function in this cell to get our desired results.

Step 2 – Write the formula and implement it

  • In the chosen cell, start by entering the equal sign (=) to initiate the formula.
  • Next, type “2*PI()” to incorporate the 2 multiplied by the value of π (pi) into the formula.
  • Following that, insert an asterisk () to indicate multiplication.
  • Then, specify the cell reference B2 as the value that will be multiplied by 2π.
  • Now that you have followed all the steps above, your formula would look like this,

=2*PI()*B2)

  • Then, press Enter and your answer would appear.
  • If you want to implement the formula to the whole range then click on the “tick ✔” option of the Auto-fill.

Case 2 – Inserting the “PI (π)” symbol

Step 1 – Select the cell

  • Select any empty cell in which you can apply the “CHAR” function to get the “PI (π)” symbol.

Step 2 – Write the formula

  • After selecting the cell, write the following formula in the cell

=CHAR(960)

  • It will give you the result as a “π” symbol.

Step 3 – Paste the “π” as Plain text

  • After we get the “π” symbol, copy it because we want to paste it as text, not a formula.
  • While writing the text where you want to insert it, right-click there and click on “Paste as Plain text” or use the shortcut key “Ctrl+Shift+V” to paste it as text.