# Alphabetical - P

 PDURATION(2013) The number of periods required by an investment to reach a specified value. PEARSONThe pearson product moment correlation coefficient. PERCENTILE(PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). PERCENTILE.EXCThe value from a data set that corresponds to a particular percentage (exclusive). PERCENTILE.INCThe value from a data set that corresponds to a particular percentage (inclusive). PERCENTRANK(PERCENTRANK.INC) The rank of a value as a percentage (inclusive). PERCENTRANK.EXCThe rank of a value as a percentage (exclusive). PERCENTRANK.INCThe rank of a value as a percentage (inclusive). PERMUTThe number of permutations for a subset of objects or events. PERMUTATIONA(2013) The number of permutations for a subset of objects or events (with repetition). PHI(2013) The value of the density function for a standard normal distribution. PHONETICThe phonetic characters from a text string. PIThe number PI (3.141592). PIVOTBY(Microsoft 365) The grouping of your data along two axis and aggregates the associated values. PMTThe full amount (principal + interest) paid every period on a loan with fixed interest. POISSON(POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. POISSON.DISTThe probability distribution function OR the cumulative probability function for a poisson distribution. POWERThe number raised to a given power. PPMTThe principal amount paid on a given period on a loan with fixed interest. PRICEThe price of a security that pays periodic interest. PRICEDISCThe price of a discounted security (no interest payments). PRICEMATThe price of a security that pays interest at maturity. PROBThe probability that the values in a data set are greater than a lower limit and less than an upper limit. PRODUCTThe product of all the numbers in a list, table or cell range. PROPERThe text string with the first letter of every word as a capital letter. PVThe present value of a series of equal cash flows at regular intervals. PY(Microsoft 365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime.