Functions

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

DATE Function in Excel

0
The Excel date function is built directly into Excel. You can use this function in a variety of useful ways.

0

CUMIPMT Function

0
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the...

RANK Function

0
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...

MAX Function

0
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

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

RANDBETWEEN Function

0
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

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

INDEX Function

0
INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row...

Match Function

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