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|