How to use Logical AND, OR and IF Functions in Excel

How to use Logical AND, OR and IF Functions in Excel

The IF function is used to perform a logical test and return one value if the condition is TRUE and another for FALSE results. Combining AND, OR, and IF function varies the condition for testing the cells. The OR and AND functions are used to test multiple conditions and depending on which function is used, … Read more

How to use COUNTIF function with multiple criteria


COUNTIF function is one of the most common excel functions used for counting numbers within a specific range. The number of cells in the range should match the supplied criteria. Users need to specify single or multiple criteria to get the result. If you want to count cells based on multiple criteria, you can use … Read more

VLOOKUP Parameters Explained in Detail with Example

VLOOKUP Parameters Explained

VLOOKUP is one of the most useful Excel functions. The function is used to search for specific values defined and returns the match-in value from another column. The VLOOKUP function, just as the name looks up a value in the first column of a specified range of cells and then returns the results on the … Read more

Excel Vlookup Multiple Criteria

Excel Vlookup Multiple Criteria

There are various methods of returning a value from a Table array based on more than one criteria. Vlookup is used when there is only one criterion (condition). In this tutorial, we will be discussing the method involving INDEX and MATCH.  Let us consider an example, see the below illustration: The Formula in C2 is: … Read more

IF Formula with Four Conditions

IF Formula with Four Conditions

Many insights derived from data analyses include determining the number of observations that meet specific characteristics. For example, an analysis of a person’s ideal automobile purchase may require that the price is below a specific dollar amount, the engine has a minimum horsepower rating, and an automatic transmission. While it is possible to scan through … Read more

Microsoft Excel Basic Formulas List

Microsoft excel basic formulas list

1. SUM This is the first Excel Function one should be familiar with. It basically performs the addition operation. The Syntax in which it is used is as follows: SUM (number1, [number2], …) Generally, arguments in square brackets are optional, the other ones are required. See it used in the example below   2. SUMIF … Read more

How to create a pivot table from multiple worksheets using Microsoft Excel 2016

pivot table

A pivot table in its simplest form of a programming tool that permits its user to summarize selected columns and rows of data in a spreadsheet. Simply put is used in sorting information and used to breaking larger tables down into easier-to-use forms. In answer to the popularly asked question on whether a pivot table … Read more