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.

Related functions

Last updated