Home » Excel » Functions » Page 6

# Functions

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

## CUMIPMT Function

How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan. This …

## RANK Function

The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending or descending order. Let’s first look …

## MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE and FALSE, and text …

## RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can be useful in a number of …

## RANDBETWEEN Function

You can use Randbetween random Number Generation for a number or purposes in Excel. The Excel RANDBETWEEN function returns a random integer (number) between a specified number range, …

## Using INDEX and Match Functions Together

Using INDEX and Match Functions together – Alternative to VLOOKUP Before reading this tutorial, please make sure you understand how to use the INDEX and MATCH function. As …

## INDEX Function

INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row and column. Syntax: INDEX(array, row_num, [column_num]) Arguments: array – …

## 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 …

Scroll to Top