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

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