Contact
12 programs
Explore the site

PI Function (LibreOffice Calc)

Math Beginner LibreOffice Calc Introduction not established

The PI function in LibreOffice Calc returns the mathematical constant π (pi), approximately 3.14159265358979. It is essential for geometry, trigonometry, and circular calculations.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **PI** function returns the mathematical constant π (pi), approximately **3.14159265358979**, in LibreOffice Calc. Pi is fundamental in geometry, trigonometry, physics, engineering, and any calculation involving circles, angles, or periodic functions. Using the PI function ensures precision and avoids manually typing approximations.

What the PI Function Does

  • Returns the constant π
  • Provides high precision (15+ digits)
  • Useful for geometry, trigonometry, and circular calculations
  • Works seamlessly with SIN, COS, TAN, POWER, and SQRT

It is designed to be simple, precise, and universally compatible.

Syntax

PI()

Arguments

  • None.
    PI is a zero‑argument function.

Basic Examples

Return the value of pi

=PI()

Returns approximately 3.141592654.

Circumference of a circle

=2 * PI() * A1

Where A1 is the radius.

Area of a circle

=PI() * A1^2

Where A1 is the radius.

Diameter from circumference

=A1 / PI()

Where A1 is the circumference.

Advanced Examples

Volume of a cylinder

=PI() * A1^2 * B1

Where:

  • A1 = radius
  • B1 = height

Arc length

=PI() * A1 * (B1 / 180)

Where:

  • A1 = diameter
  • B1 = angle in degrees

Convert degrees to radians manually

=A1 * PI() / 180

Equivalent to the RADIANS function.

Convert radians to degrees manually

=A1 * 180 / PI()

Equivalent to the DEGREES function.

Trigonometric calculations

=SIN(PI() / 2)

Returns 1.

Half‑circle area

=PI() * A1^2 / 2

Sector area

=PI() * A1^2 * (B1 / 360)

Where B1 is the angle in degrees.

Common Errors and Fixes

PI returns Err:501

Occurs when:

  • Parentheses are missing
    Example: =PI instead of =PI()

PI used incorrectly in formulas

Common mistakes:

  • Forgetting parentheses
  • Mixing degrees and radians
  • Using PI instead of PI()

Fix:
Always use PI() and ensure angle units are correct.

Best Practices

  • Always use PI() instead of typing 3.14 or 3.14159
  • Use PI() with RADIANS/DEGREES for angle conversions
  • Use PI() in geometry, trigonometry, and periodic functions
  • Combine PI() with POWER for circular area and volume formulas
Using PI() ensures maximum precision and avoids rounding errors from manually typed approximations.
  • Use RADIANS to convert degrees to radians
  • Use DEGREES to convert radians to degrees
  • Use SIN, COS, TAN for trigonometric calculations
  • Use POWER and SQRT for geometric formulas
  • Use 2 * PI() for full‑circle calculations

By mastering PI and its combinations with other math functions, you can build precise geometric and trigonometric models in LibreOffice Calc that rely on accurate circular calculations.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=ROUND(PI();4)

Expected result: 3.1416.

Insert the mathematical constant π.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.