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 |