In this article:

How to Use Pi in Google Sheets (2024 Guide)

March 15, 2024

How to Use Pi in Google Sheets

Step 1: Enter the Formula for Pi

Type = into the cell to begin your formula. After the equals sign, type PI(). Make sure to press the Enter key on your keyboard.

pi in google sheets

Step 2: Check the Result

Once you press Enter, the cell will display the value of Pi. It will show a numerical approximation of Pi.

google sheets pi

Step 3: Using Pi in Calculations

If you want to use Pi in a calculation (for instance, to calculate the circumference of a circle), you can include the PI() function in your formula. For example, to calculate the circumference of a circle with a radius of 5, you would use the formula =2*PI()*5.

how to use pi in google sheets

How to Insert Pi in Google Sheets

To quickly insert the Pi symbol (π), you would use the Unicode or ASCII code for the Pi symbol. In Google Sheets, the Unicode for the Pi symbol is 960. Therefore, you would use =CHAR(960).

Below is how you can input it:

pi google sheets
how to insert pi in google sheets

We hope that this article has helped you and given you a better understanding of how to use Pi in Google Sheets. If you enjoyed this article, you might also like our articles on how to swap cells in Google Sheets and how to capitalize the first letter in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks
  • Covers pivot tables and other advanced topics
  • 100% free

Automate repetitive spreadsheet tasks with Lido

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->