Excel Functions

Syntax and Description with examples

Search now!
Generic filters
Filter by Categories
Free Excel Macro
Premium Excel Macro
Add ins
Templates
VBA Codes

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