Basic Excel Simple formulas

​How to Use IF Function Formula in Excel Excel IF function Formula IF function Formula is one of the Excel's logical function Formula that evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE. The syntax for Excel IF Function Formula is as follows: IF(logical_test, [value_if_true], [value_if_false]) As you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional. Some List of Example : ​Example : 1 * logical_test  - a value or logical expression that can be either TRUE or FALSE. Required.In this argument, you can specify a text value, date, number, or any comparison operator. For example, your logical test can be expressed as or A1="Yes", A1<200, A1=5000 or A1>500. * value_if_true  - the value to return when the logical test evaluates to TRUE, i.e. if the condition is met. Optional.For example, the following form

Combining the INDEX Function Formula with MATCH Function Formula In Excel INDEX Function Formula With MATCH Function Formula need to specify more complex conditions when writing your formula in Excel. You can combine the INDEX function Formula with MATCH functions Formula This Function Formula is Most Useful to Reverse LOOKUP Find, Look like Similar to VLOOKUP Function Formula,  VLOOKUP Find Right Side Column Value and INDEX With MATCH Function Formula Find Left Side Column Value For Example :  A                          B                             C                                     D Qty           Product Name                 Product Name              Qty    (Result) 5854            Saree                               Tunic                              552    8582             Dress Material                Shirt                               2524 2854             Tops                                Saree                             5854  2524             Shirt               

How to Use VLOOKUP Function Formula in Excel VLOOKUP Function Formula is one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up an Product Quantity, Product Details or Product SKU, find any phone number by looking up Their last name (just like a telephone book Directory). The secret to VLOOKUP Function Formula  is to organize your data so that the value you look up (Product Quantity) is to the left of the return value you want to find (Product Quantity's).    VLOOKUP Function Formula Syntax : -  =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) For Example : -      Argument name                      Description lookup_value     (required)         Which value you want to look up. Which value you want to look up must be in the first column of the range of cells you specify in   table-array    (Lookup Value is C)   For example, if   table-array   spans cells A:B, then your lookup_value