# Functions

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

## Match Function

Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once you look at the example. Syntax =MATCH(lookup_value, lookup_array, …

## FV Function – Future Value

The FV Function [Future Value calculation] is built into Excel. It is a financial function used to calculate the Future Value of an investment.  This function assumes constant …

## COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1, [range2], [criteria2], …) *It is vital to add the parenthesis surrounding …

## DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert …

## COUNTIF Function

The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are …

## PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula will not work with a flexible …

Scroll to Top