Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| PMT | Financial |
 |
Returns the periodic payment for an annuity |
| POISSON | Compatibility |
|
Returns the Poisson distribution |
| POISSON.DIST | Statistical |
|
Returns the Poisson distribution |
| POWER | Math and trigonometry |
|
Returns the result of a number raised to a power |
| PPMT | Financial |
|
Returns the payment on the principal for an investment for a given period |
| PRICE | Financial |
|
Returns the price per $100 face value of a security that pays periodic interest |
| PRICEDISC | Financial |
|
Returns the price per $100 face value of a discounted security |
| PRICEMAT | Financial |
|
Returns the price per $100 face value of a security that pays interest at maturity |
| PROB | Statistical |
|
Returns the probability that values in a range are between two limits |
| PRODUCT | Math and trigonometry |
|
Multiplies its arguments |
| PROPER | Text |
|
Capitalizes the first letter in each word of a text value |
| PV | Financial |
|
Returns the present value of an investment |
| QUARTILE | Compatibility |
|
Returns the quartile of a data set |
| QUARTILE.EXC | Statistical |
|
Returns the quartile of the data set, based on percentile values from 0..1, exclusive |
| QUARTILE.INC | Statistical |
|
Returns the quartile of a data set |
| QUOTIENT | Math and trigonometry |
|
Returns the integer portion of a division |
| RADIANS | Math and trigonometry |
|
Converts degrees to radians |
| RAND | Math and trigonometry |
|
Returns a random number between 0 and 1 |
| RANDBETWEEN | Math and trigonometry |
|
Returns a random number between the numbers you specify |
| RANK | Compatibility |
|
Returns the rank of a number in a list of numbers |
