Return Min, Max, or Average Using Vlookup in Excel
It is nothing unusual to combine a few Excel formulas to get the results we need. Such is the case with the VLOOKUP…
Category: formulas
Find the Average of Excel Range Ignoring Zeroes
Sometimes we may want to exclude zero values in the calculation of the average of a range. This tutorial shows how to find…
Get nth Match with INDEX, MATCH, and SMALL in Excel
We can use the combination of INDEX, MATCH, and SMALL functions to find the data that is in the nth position of a…
Selling Price Formula in Excel
The selling price is the amount a customer pays to buy a product or service. We show you how to calculate a product’s…
INDEX and MATCH with the LARGE Function in Excel
Finding cells that meet multiple criteria is a common task in Excel. In this tutorial, we look at how to use the combination…
Convert Number of Days to Weeks in Excel
Sometimes we may want to convert the number of days into weeks in Excel summary reports. Convert Number of Days to Weeks in…
Convert UTC to EST in Excel
To convert Coordinated Universal Time (UTC) to Eastern Standard Time (EST) in Excel we first must know the time difference between the two….
Find the Area of a Circle Using Excel
The area of a circle is the extent of the two-dimensional surface enclosed within the circumference of the circle. It is measured in…
Produce Multiple Outputs in an IF Statement in Excel
The Excel IF function checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. The syntax…
Find and Remove Duplicates in Excel Using VLOOKUP
One of the most widely used formulas in Excel is VLOOKUP. This formula is used mostly in cases when we need to find…