Alphabetical - P

PDURATIONThe 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.
PERMUTATIONAThe number of permutations for a subset of objects or events (with repetition).
PHIThe value of the density function for a standard normal distribution.
PHONETICThe phonetic characters from a text string.
PIThe number PI (3.141592).
PIVOTBY(2023) Preview. 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 numerical values.
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(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