# Functions

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

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

Scroll to Top