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.
| IMLN | Engineering |
 |
Returns the natural logarithm of a complex number |
| IMLOG10 | Engineering |
|
Returns the base-10 logarithm of a complex number |
| IMLOG2 | Engineering |
|
Returns the base-2 logarithm of a complex number |
| IMPOWER | Engineering |
|
Returns a complex number raised to an integer power |
| IMPRODUCT | Engineering |
|
Returns the product of complex numbers |
| IMREAL | Engineering |
|
Returns the real coefficient of a complex number |
| IMSEC | Engineering |
|
Returns the secant of a complex number |
| IMSECH | Engineering |
|
Returns the hyperbolic secant of a complex number |
| IMSIN | Engineering |
|
Returns the sine of a complex number |
| IMSINH | Engineering |
|
Returns the hyperbolic sine of a complex number |
| IMSQRT | Engineering |
|
Returns the square root of a complex number |
| IMSUB | Engineering |
|
Returns the difference between two complex numbers |
| IMSUM | Engineering |
|
Returns the sum of complex numbers |
| IMTAN | Engineering |
|
Returns the tangent of a complex number |
| INDEX | Lookup and reference |
|
Uses an index to choose a value from a reference or array |
| INDIRECT | Lookup and reference |
|
Returns a reference indicated by a text value |
| INFO | Information |
|
Returns information about the current operating environment |
| INT | Math and trigonometry |
|
Rounds a number down to the nearest integer |
| INTERCEPT | Statistical |
|
Returns the intercept of the linear regression line |
| INTRATE | Financial |
|
Returns the interest rate for a fully invested security |
