Home Excel Functions

Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

ISERROR

ISERROR Function

0
The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!,...
PPMT-Function

PPMT Function

0
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to...
NPER Function

NPER Function

0
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...
CUMPRINC Function

CUMPRINC Function

0
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...
YEARFRAC Function

YEARFRAC Function

0
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:
Year Function

YEAR Function

0
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out...

WORKDAY.INTL Function

0
Workday.intl Function
WORKDAY Function

WORKDAY Function

0
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....
WEEKNUM Function

WEEKNUM Function

0
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...
ROUNDDOWN Function

ROUNDDOWN Function

0
The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.

Latest Tutorials