# Functions

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

## XLOOKUP Horizontal Lookup

Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform […]

## ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! It is

## PPMT Function

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

## NPER Function

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

## CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your

## YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date. end_date

Scroll to Top