It is often required in Excel to find out the total number of working days between two dates. Usually while counting this, we often neglect the weekends and holidays. Excel has two different ...

In this tutorial, we will be working on the nested if function in Excel. We will analyze the If function with 3 conditions in Excel. Here we will see the examples of multiple if functions along with ...

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the measurement on how the numbers of data are distributed ...

While doing different tasks in Excel we often come across a situation where the matching and differences of two or multiple columns are required. It's not a difficult task to compare two lists in ...

Excel provides a wide variety of functions to handle date calculations. We have already looked at some of these functions in previous tutorials. The EDATE function is utilized, when one wants to add ...

Performing operations and calculations involving dates requires that one acquires familiarity with some of Excel’s Date and Time Functions.The DATEDIF worksheet Function in Excel calculates the ...

Excel provides functions to calculate the largest or maximum value in a range and also functions to calculate the smallest or minimum value in a range.The first function we are going to look at ...

The OR Function is a logical Function, that evaluates two or more conditions and returns true if at least one of the conditions is true. If all of the conditions are found to be false, then the OR ...

We have already seen how to utilize the VLOOKUP Function in a previous tutorial. We are now going to see how to use the HLOOKUP Function. HLOOKUP stands for horizontal lookup and is used when the ...

The XOR Function is a logical function that was introduced in Excel 2013 and later versions. The XOR Function if used with two conditions and one of the conditions evaluates to true, then the XOR ...

The CEILING.MATH Function is a new function that was introduced in Excel 2013 and later versions. The CEILING.MATH Function rounds a specified number up to the nearest integer or nearest specified ...

Excel provides multiple functions for rounding numbers in one’s worksheet. The most often utilized are namely the ROUND Function, the ROUNDUP Function, the ROUNDDOWN Function, the MROUND Function and ...

The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April ...

The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula ...

Have you ever wondered how to count the frequency of text in Excel, i.e the number of times a specific text appears in a range? We have already seen how to use the different COUNTING functions in a ...