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 …

RANK Function Read More »

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 …

MAX Function Read More »

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

INDEX Function Read More »

Scroll to Top