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”