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.
| WORKDAY.INTL | Date and time |
 |
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days |
| XIRR | Financial |
|
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
| XNPV | Financial |
|
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
| XOR | Logical |
|
Returns a logical exclusive OR of all arguments |
| YEAR | Date and time |
|
Converts a serial number to a year |
| YEARFRAC | Date and time |
|
Returns the year fraction representing the number of whole days between start_date and end_date |
| YIELD | Financial |
|
Returns the yield on a security that pays periodic interest |
| YIELDDISC | Financial |
|
Returns the annual yield for a discounted security; for example, a Treasury bill |
| YIELDMAT | Financial |
|
Returns the annual yield of a security that pays interest at maturity |
| Z.TEST | Statistical |
|
Returns the one-tailed probability-value of a z-test |
| ZTEST | Compatibility |
|
Returns the one-tailed probability-value of a z-test |