# 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 number corresponding to a particular percentage from an array of numbers (inclusive). |

PERCENTILE.EXC | The number corresponding to a particular percentage from an array of numbers (exclusive). |

PERCENTILE.INC | The number corresponding to a particular percentage from an array of numbers (inclusive). |

PERCENTRANK | (PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |

PERCENTRANK.EXC | The percentage rank of a value in an array of numbers (exclusive). |

PERCENTRANK.INC | The percentage rank of a value in an array of numbers (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). |

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 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 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 number corresponding to a particular percentage from an array of numbers (inclusive). |

PERCENTILE.EXCThe number corresponding to a particular percentage from an array of numbers (exclusive). |

PERCENTILE.INCThe number corresponding to a particular percentage from an array of numbers (inclusive). |

PERCENTRANK(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |

PERCENTRANK.EXCThe percentage rank of a value in an array of numbers (exclusive). |

PERCENTRANK.INCThe percentage rank of a value in an array of numbers (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). |

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 values in a range are between two limits. |

PRODUCTThe product of all the numbers in a list 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. |

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