PI Function (OpenOffice Calc)
The PI function in OpenOffice Calc returns the mathematical constant π (pi). Learn syntax, usage in geometry, trigonometry, and advanced formulas.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the PI Function Does ▾
- Returns the constant π
- Useful for geometry, trigonometry, and scientific formulas
- Works across sheets
- Provides full double‑precision accuracy
PI is ideal whenever a formula involves circles, angles, or periodic functions.
Syntax ▾
PI()
Arguments:
- None — PI takes no parameters.
PI always returns the same constant value:
3.14159265358979
3.14159265358979
Basic Examples ▾
Return the value of π
=PI()
Multiply π by a number
=2 * PI()
Convert degrees to radians
=Degrees * PI() / 180
Convert radians to degrees
=Radians * 180 / PI()
Geometry Examples ▾
Circumference of a circle
=2 * PI() * Radius
Area of a circle
=PI() * Radius^2
Volume of a cylinder
=PI() * Radius^2 * Height
Surface area of a sphere
=4 * PI() * Radius^2
Volume of a sphere
=4/3 * PI() * Radius^3
Trigonometry Examples ▾
Sine of 90 degrees
=SIN(90 * PI() / 180)
Cosine of π radians
=COS(PI())
Convert angle to radians inside trig functions
=SIN(A1 * PI() / 180)
Periodic wave function
=SIN(2 * PI() * Frequency * Time)
Advanced Examples ▾
Gaussian (normal) distribution constant
=1 / (SQRT(2 * PI()) * sd)
Fourier series component
=SIN(2 * PI() * n * x)
Circle sector area
=0.5 * Radius^2 * AngleRadians
Arc length
=Radius * AngleRadians
PI across sheets
=PI()
(PI is constant, but can be used anywhere.)
Polar to Cartesian conversion
X:
=Radius * COS(ThetaRadians)
Y:
=Radius * SIN(ThetaRadians)
Cartesian to polar angle
=ATAN2(Y; X)
(Uses radians; PI helps convert to degrees.)
Common Errors and Fixes ▾
PI returns Err:508 (Missing parenthesis)
Occurs when:
- You forget the parentheses:
=PIinstead of=PI() - You mix commas and semicolons
PI returns unexpected results
Possible causes:
- Using degrees in trig functions without converting
- Incorrect parentheses in formulas
- Hidden text values in calculations
PI ignores values you expected it to include
PI ignores:
- All arguments (it takes none)
- Text
- Logical values
PI includes values you expected it to ignore
PI includes:
- Nothing — it is a constant
Best Practices ▾
- Always convert degrees to radians using
* PI() / 180 - Use PI for all geometry and trigonometry formulas
- Use named ranges for radius, angle, and frequency for clarity
- Keep parentheses clean in multi‑step formulas
- Use PI with POWER for circle and sphere formulas
If a formula involves circles, angles, waves, or rotations, PI is almost always part of the solution.