# Alphabetical - P

PDURATION | (2013) The number of periods required by an investment to reach a specified value. |

PEARSON | The pearson product moment correlation coefficient. |

PERCENTILE | (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |

PERCENTILE.EXC | The value from a data set that corresponds to a particular percentage (exclusive). |

PERCENTILE.INC | The 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.EXC | The rank of a value as a percentage (exclusive). |

PERCENTRANK.INC | The rank of a value as a percentage (inclusive). |

PERMUT | The 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. |

PHONETIC | The phonetic characters from a text string. |

PI | The number PI (3.141592). |

PIVOTBY | (Microsoft 365) The grouping of your data along two axis and aggregates the associated values. |

PMT | The 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.DIST | The probability distribution function OR the cumulative probability function for a poisson distribution. |

POWER | The number raised to a given power. |

PPMT | The principal amount paid on a given period on a loan with fixed interest. |

PRICE | The price of a security that pays periodic interest. |

PRICEDISC | The price of a discounted security (no interest payments). |

PRICEMAT | The price of a security that pays interest at maturity. |

PROB | The probability that the values in a data set are greater than a lower limit and less than an upper limit. |

PRODUCT | The product of all the numbers in a list, table or cell range. |

PROPER | The text string with the first letter of every word as a capital letter. |

PV | The 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. |

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. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top