Jak używać funkcji PI w Excelu
The PI function in spreadsheet programs, including both Microsoft Excel and Google Sheets, is used to return the value of π (pi), which is instrumental in computations relating to circles, spheres, and spherical geometries. Below are details about its application and examples that will help you understand how to practically use this function.
Overview and Syntax of the Function
The PI function does not require any arguments, making it one of the simplest functions to use. To use it, simply enter:
=PI()
The result of this function is the number 3.14159265358979, which is the approximate value of π to 15 decimal places.
Examples of Application in Calculations
- Calculating the circumference of a circle
- Calculating the area of a circle
Calculating the Circumference of a Circle
To calculate the circumference of a circle, the radius is required. The circumference of a circle equals 2πr. Example:
=2*PI()*A1
Where A1 contains the value of the radius. If the value in cell A1 is 3, the result of the function will be the circumference of a circle with a radius of 3.
Radius | Circumference |
---|---|
3 | =2*PI()*3 ≈ 18.85 |
5 | =2*PI()*5 ≈ 31.42 |
Calculating the Area of a Circle
To calculate the area of a circle, the formula πr² is used. For example:
=PI()*A2^2
Where A2 is the cell containing the value of the radius. If the radius in cell A2 is 4, the function will return the area of a circle with that radius.
Radius | Area |
---|---|
4 | =PI()*4^2 ≈ 50.27 |
7 | =PI()*7^2 ≈ 153.94 |
The examples provided demonstrate how simple it can be to apply mathematical formulas in spreadsheet software like Microsoft Excel and Google Sheets for everyday data work related to plane geometry. The PI function, though basic, is incredibly useful across a wide range of engineering, scientific, and educational applications.
Więcej informacji: https://support.microsoft.com/pl-pl/office/pi-funkcja-264199d0-a3ba-46b8-975a-c4a04608989b