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 – […]
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
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,
FV Function – Future Value
The FV Function [Future Value calculation] is built into Excel. It is a financial function used to calculate the Future Value of an investment. This function assumes constant
FV Function – Future Value 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
DATEVALUE Function
The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert
DATEVALUE Function Read More »
COUNTIF Function
The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are