Function Type: Logical Description: AND function returns TRUE if all of its arguments are TRUE.1 FALSE argument will result in FALSE.This is most commonly used with IF function which also needs logical tests.  Logical test results in a TRUE or FALSE.Logical tests utilize Logical Operators. Then we can assign two differentContinue reading “AND function”
Tag Archives: functions
SUMIFS function
SUMIFS function adds the cell values based on specified criteria.
INDEX function
Function Type: Lookup and Reference Description: INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value. Function Structure: =INDEX(array, row_number, [column_number]) Argument Breakdown: array – This is the group of cells where your excelContinue reading “INDEX function”
IF function
Function Type: Logical Description: IF is one of the most popular functions in Excel. It checks if the condition is met then it returns a value. It is used to return one value if the logic is true and another value if false. Function Structure: =IF(logical_test, [value_if_true], [value_if_false]) Argument Breakdown: logical_test – This is whereContinue reading “IF function”
VLOOKUP
Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either lookup for the exact or approximate match. The “V” in Vlookup means Vertical. Function Structure: =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]) ArgumentContinue reading “VLOOKUP”