Get Your Numbers Right
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. Same as Excel's built-in PI function, but with high 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.
|digits||Optional. The number of digits of Pi to return. Default is 100, or the maximum allowed by the xlPrecision edition, whichever is less. Maximum is 32,767.|
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.
|=xlpPI(25)||The first 25 digits of Pi||3.141592653589793238462643|