Category: formulas

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…

To check whether a cell contains the specific text, you can use the SEARCH function. This function will return the position of the…

If you want to check whether the particular date is between two other dates, you can easily do it in Excel. In the…

Using VLOOKUP between to worksheets is very similar to using VLOOKUP on the same worksheet. We are going to use two sheets (Sheet1…