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.
| IPMT | Financial |
 |
Returns the interest payment for an investment for a given period |
| IRR | Financial |
|
Returns the internal rate of return for a series of cash flows |
| ISBLANK | Information |
|
Returns TRUE if the value is blank |
| ISERR | Information |
|
Returns TRUE if the value is any error value except #N/A |
| ISERROR | Information |
|
Returns TRUE if the value is any error value |
| ISEVEN | Information |
|
Returns TRUE if the number is even |
| ISFORMULA | Information |
|
Returns TRUE if there is a reference to a cell that contains a formula |
| ISLOGICAL | Information |
|
Returns TRUE if the value is a logical value |
| ISNA | Information |
|
Returns TRUE if the value is the #N/A error value |
| ISNONTEXT | Information |
|
Returns TRUE if the value is not text |
| ISNUMBER | Information |
|
Returns TRUE if the value is a number |
| ISO.CEILING | Math and trigonometry |
|
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance |
| ISODD | Information |
|
Returns TRUE if the number is odd |
| ISOWEEKNUM | Date and time |
|
Returns the number of the ISO week number of the year for a given date |
| ISPMT | Financial |
|
Calculates the interest paid during a specific period of an investment |
| ISREF | Information |
|
Returns TRUE if the value is a reference |
| ISTEXT | Information |
|
Returns TRUE if the value is text |
| JIS | Text |
|
Changes half-width (single-byte) characters within a string to full-width (double-byte) characters |
| KURT | Statistical |
|
Returns the kurtosis of a data set |
| LARGE | Statistical |
|
Returns the k-th largest value in a data set |
