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...

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...

RAND Function

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

RANDBETWEEN Function

You can use Randbetween random Number Generation for a number or purposes in Excel. The Excel RANDBETWEEN function returns a random integer...

Using INDEX and Match Functions Together

Using INDEX and Match Functions together – Alternative to VLOOKUPBefore reading this tutorial, please make sure you understand...

INDEX Function

INDEX Function in ExcelThe Index Function returns the value of an array given a specific row and column....

Match Function

Match FunctionThe Match Function searches for a specified value and returns relative position of that value. It’s easier once you...

FV Function – Future Value

The FV Function is built into Excel. It is a financial function used to calculate the Future Value of an investment. ...

COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria.=COUNTIFS (range1, criteria1,...

DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text.=DATEVALUE (date_text)

Latest Tutorials