Category: formulas

Normally, when you use VLOOKUP, you are going to check a single condition. VLOOKUP can’t use more than one condition until you modify…

Calculating the number of days between two days is easy and pretty straightforward. You have to subtract an older date from the newer….

You can use the MATCH function to get the column number and the INDEX function to get the column name. Get column index…

When you want to look up a value in a table based on another cell, you can use VLOOKUP function. But there is…

When working with Excel, you probably noticed that there are two methods of joining strings. One of them is by using the ampersand…

Sometimes, displaying the very precise number is not useful and you may want to round the value. But there may be cases when…

If you want a formula that inserts a text, instead of leaving blank cells, you can use the ISBLANK function. This function returns…

If you have a list of percentage values and you want to get the average percentage of them, you can do it in…

Excel usually allows you to do the different calculation in a few different ways. It’s also the case if you want to do…

Calculating ranges is easy. But have you ever tried to calculate a range based on the number in a specific cell? In this…