MID function in excel worksheet

Excel Version in which MID function can work: MID function will work in Excel 2016, Excel 2013, and Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000. About MID function: MID worksheet function extracts specified number of letters from a word. This is a built in function in excel … Read more

IF with AND formula for multiple logical tests.

How to use IF with AND function..? In our previous post IF function and nested IF function is explained with the example. Similarly, instead of using Nested IF function IF with AND formula can be used for testing multiple logical tests to give the results. AND Function: In AND logic, different logical test can be done. … Read more

Left, Right and Len functions in excel

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the referred cell. If the number … Read more

How to use VLOOKUP in excel

VLOOKUP in excel is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP in excel: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value  is the … Read more

SUMIFS Functions in Excel

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) The sequence of arguments are different in … Read more

How to use Excel SUMIF Formula

In this article we have explained how to use Excel SUMIF Formula. Excel SUMIF function can be used to sum the value in a range that meets the given criteria.  Syntax for Excel SUMIF Formula is:  =SUMIF(range, criteria,[sum_range]) range is the argument that specifies the cells in which the criteria or the condition is to be … Read more