Category: formulas

Suppose you have a dataset in Excel that has long numbers. To improve readability, you may want to convert the numbers to text…

Sometimes you may want to check if cells in a worksheet contain any text. This tutorial shows you a technique for checking if…

At times you may want to check if cells in an Excel worksheet contain numeric characters. This tutorial shows you one technique for…

Excel is a perfect tool for all mathematical operations and visual presentation of data. It can be used to combine the two, as…

It is nothing unusual to combine a few Excel formulas to get the results we need. Such is the case with the VLOOKUP…

Sometimes we may want to exclude zero values in the calculation of the average of a range. This tutorial shows how to find…

We can use the combination of INDEX, MATCH, and SMALL functions to find the data that is in the nth position of a…

The selling price is the amount a customer pays to buy a product or service. We show you how to calculate a product’s…

Finding cells that meet multiple criteria is a common task in Excel. In this tutorial, we look at how to use the combination…

Sometimes we may want to convert the number of days into weeks in Excel summary reports. Convert Number of Days to Weeks in…