| PEARSON | The Pearson product moment correlation coefficient. |
| PERCENTILE | The Kth percentile of values in an array of numbers. |
| PERCENTRANK | The percentage rank of a value in an array of numbers. |
| PERMUT | The number of permutations from a given number. |
| PHONETIC | The phonetic characters from a text string. |
| PI | The number PI (3.141592). |
| PMT* | The payment for a loan with constant payments and fixed interest. |
| POISSON | The Poisson distribution. |
| POWER | The number raised to a given power. |
| PPMT | The payment on principle for a given period for an investment. |
| PRICE* | The price per $100 face value of a security. |
| PRICEDISC* | The price per $100 face value of a discounted security. |
| PRICEMAT* | The price per $100 face value of a security that pays interest at maturity. |
| PROB | The probability that values in a range are between two limits. |
| PRODUCT | The product of all the numbers in a list or cell range. |
| PROPER | The text string with the first letter of every word as a capital letter. |
| PV | The present value of an investment. |
