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.
| NEGBINOMDIST | Compatibility |
 |
Returns the negative binomial distribution |
| NETWORKDAYS | Date and time |
|
Returns the number of whole workdays between two dates |
| NETWORKDAYS.INTL | Date and time |
|
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days |
| NOMINAL | Financial |
|
Returns the annual nominal interest rate |
| NORM.DIST | Statistical |
|
Returns the normal cumulative distribution |
| NORM.INV | Compatibility |
|
Returns the inverse of the normal cumulative distribution |
| NORM.S.DIST | Statistical |
|
Returns the standard normal cumulative distribution |
| NORM.S.INV | Statistical |
|
Returns the inverse of the standard normal cumulative distribution |
| NORMDIST | Compatibility |
|
Returns the normal cumulative distribution |
| NORMINV | Statistical |
|
Returns the inverse of the normal cumulative distribution |
| NORMSDIST | Compatibility |
|
Returns the standard normal cumulative distribution |
| NORMSINV | Compatibility |
|
Returns the inverse of the standard normal cumulative distribution |
| NOT | Logical |
|
Reverses the logic of its argument |
| NOW | Date and time |
|
Returns the serial number of the current date and time |
| NPER | Financial |
|
Returns the number of periods for an investment |
| NPV | Financial |
|
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
| NUMBERVALUE | Text |
|
Converts text to number in a locale-independent manner |
| OCT2BIN | Engineering |
|
Converts an octal number to binary |
| OCT2DEC | Engineering |
|
Converts an octal number to decimal |
| OCT2HEX | Engineering |
|
Converts an octal number to hexadecimal |
