Alphabetical - P
PDURATION | 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 | The number of permutations for a subset of objects or events (with repetition). |
PHI | 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 | (2023) Preview. 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 numerical values. |
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 | (2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
PDURATION 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 The number of permutations for a subset of objects or events (with repetition). |
PHI 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 (2023) Preview. 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 numerical values. |
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 (2023) New. 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