xl
Precision
Get Your Numbers Right
xlpPI
Returns the mathematical constant Pi, the ratio of circumference of a circle divided by its diameter, with up to 32,767 significant digits of precision. Pi is the same for all circles. Pi's decimal places continue infinitely and never repeat. The Greek letter Pi (π) was first used to represent the ratio in 1706.
Syntax
xlpPI(digits)
| digits | Optional. The number of digits of Pi to return. Default is the maximum allowed by the xlPrecision edition. Maximum is 32,767. |
Remarks
xlPrecision results are returned as text that look like numbers, not as values that Excel recognizes as numbers. This is because Excel would truncate the results to 15 significant digits if it recognized them as numbers.
You can use the results of xlPrecision functions as the operands in other xlPrecision formulas without losing any precision, but using them as operands in Excel's arithmetic functions will truncate them to 15 significant digits.
Examples
| Formula | Description | Result |
| =xlpPI(25) | The first 25 digits of Pi | 3.141592653589793238462643 |