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.EXC(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC(2010) 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(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC(2010) The 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 payment for a loan with constant payments and fixed interest.
POISSON(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
POWERThe number raised to a given power.
PPMTThe fixed payment made in each period of a series of equal cash flows at regular intervals.
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.
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
(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC
(2010) 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
(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC
(2010) 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 payment for a loan with constant payments and fixed interest.
POISSON
(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST
(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
POWER
The number raised to a given power.
PPMT
The fixed payment made in each period of a series of equal cash flows at regular intervals.
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.

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