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.
| ODD | Math and trigonometry |
 |
Rounds a number up to the nearest odd integer |
| ODDFPRICE | Financial |
|
Returns the price per $100 face value of a security with an odd first period |
| ODDFYIELD | Financial |
|
Returns the yield of a security with an odd first period |
| ODDLPRICE | Financial |
|
Returns the price per $100 face value of a security with an odd last period |
| ODDLYIELD | Financial |
|
Returns the yield of a security with an odd last period |
| OFFSET | Lookup and reference |
|
Returns a reference offset from a given reference |
| OR | Logical |
|
Returns TRUE if any argument is TRUE |
| PDURATION | Financial |
|
Returns the number of periods required by an investment to reach a specified value |
| PEARSON | Statistical |
|
Returns the Pearson product moment correlation coefficient |
| PERCENTILE | Compatibility |
|
Returns the k-th percentile of values in a range |
| PERCENTILE.EXC | Statistical |
|
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive |
| PERCENTILE.INC | Statistical |
|
Returns the k-th percentile of values in a range |
| PERCENTRANK | Compatibility |
|
Returns the percentage rank of a value in a data set |
| PERCENTRANK.EXC | Statistical |
|
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set |
| PERCENTRANK.INC | Statistical |
|
Returns the percentage rank of a value in a data set |
| PERMUT | Statistical |
|
Returns the number of permutations for a given number of objects |
| PERMUTATIONA | Statistical |
|
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
| PHI | Statistical |
|
Returns the value of the density function for a standard normal distribution |
| PHONETIC | Text |
|
Extracts the phonetic (furigana) characters from a text string |
| PI | Math and trigonometry |
|
Returns the value of pi |
