PI
Return π (3.14159265358979) to full floating-point precision.
Syntax
PI() Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=PI() | 3.14 | Shown to two decimal places; the stored value is not rounded. |
=PI()>3.14159 | TRUE | The full precision is there even though the cell does not show it. |
=PI()*5^2 | 78.54 | The area of a circle with radius 5. |
=DEGREES(PI()) | 180 | π radians is half a turn. |
What the cell shows is not what it holds
PI() displays as 3.14, but the value underneath is π to about fifteen
significant figures, and every calculation uses that. Typing 3.14 instead is a
genuine loss of precision:
=PI()=3.14 → FALSE
Brackets are required
PI takes no arguments, but it is still a function call, so it is written
PI(). Without the brackets it is read as a name.
Angles
The trigonometric functions work in radians, where a full turn is 2*PI().
RADIANS and DEGREES do the
conversion by multiplying or dividing by PI()/180, which is clearer than
writing that factor into every formula.
Excel compatibility
Matches Excel. Takes no arguments, but the brackets are still required.