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)
