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.

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 »

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

Match Function Read More »

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 …

COUNTIFS Function Read More »

Scroll to Top