HomeApplicationOffice informationPI (PI Function) in Excel - How to use PI numbers in Excel

PI (PI Function) in Excel - How to use PI numbers in Excel

PI (PI Function) in Excel - How to use PI numbers in Excel Picture 1

Pi number is a mathematical constant with an approximate value of 3,1415926535897 .

Pi numbers can be found in many trigonometric and geometric formulas. Especially the formulas related to circles, ellipses, and spheres:

  1. The circumference of a circle is equal to the product of Pi and the diameter.
  2. The area of ​​a circle is equal to the product of Pi and the square of the radius.

Excel developed the Pi function to help users apply trigonometric formulas when using software. This article software tips will guide you the syntax and usage of Pi constants in Excel.

Function syntax: = PI () .

Pi function has no arguments.

Example 1: In a cell A1, type the formula = PI () , the result is: 3.141593 .

PI (PI Function) in Excel - How to use PI numbers in Excel Picture 2

Example 2: You have the diameter of the circle in cell B2 and need to calculate the circumference of the circle in cell B4 and the area of ​​the circle in that B5. You apply the following geometric formula:

B4 = PI () * 2 * B2,

B5 = PI () * B2 ^ 2.

And you get the following result:

PI (PI Function) in Excel - How to use PI numbers in Excel Picture 3

Above Dexterity software has guided you to read the function syntax and how to use the Pi function in Excel. Good luck.

5 ★ | 1 Vote

You should read it

May be interested

  • How to blur images in WordPhoto of How to blur images in Word
    you want to insert an image into word but do not want that image to stand out as a blur for the writing, so you want to find a way to blur the image in word. so, please refer to the following article to learn how to blur images in word.
  • Synthetic wallpaper for the most beautiful WordPhoto of Synthetic wallpaper for the most beautiful Word
    you are looking for beautiful word wallpapers to choose the right beautiful wallpaper for your word document. so, please refer to the most beautiful word wallpapers that tipsmake.com has summarized and shared below.
  • How to hide the Sheet Tabs (sheet bar) in ExcelPhoto of How to hide the Sheet Tabs (sheet bar) in Excel
    how to hide the sheet tabs (sheet bar) in excel. the sheet tab is the sheet that contains the worksheets of a workbook, here you can see which workbooks this sheet currently contains. typically, the sheet tab bar is shown in the lower left corner of the excel window.
  • How to adjust line spacing and line spacing in ExcelPhoto of How to adjust line spacing and line spacing in Excel
    how to adjust line spacing and line spacing in excel line spacing (the height of the line) makes your spreadsheet look better and more synchronized. today dexterity software will guide you how to adjust the height of the line so fast and most beautiful offline!
  • How to use Conditional Formatting to conditional formatting in ExcelPhoto of How to use Conditional Formatting to conditional formatting in Excel
    excel has a condititional formatting tool that is quite adequate for the needs of users. however, the built-in formats of excel are not enough to meet your needs, excel supports users to easily create new rules.
  • Filter data that doesn't overlap in Excel - Filter for unique values ​​in ExcelPhoto of Filter data that doesn't overlap in Excel - Filter for unique values ​​in Excel
    in a spreadsheet with large information data, it is difficult to check and filter which data is duplicated and which is not. especially if you manually / eye check it is very time consuming. thankfully, excel has a tool that makes it possible for users to filter for duplicate values ​​in excel (unique values).

Office information