Category: formulas

When you deal with several cells inside your spreadsheet data, adding commas manually in particular places inside cells may be a good decision,…

In this example, we are going to calculate the change in revenue for the first 6 months of the year. For this lesson,…

By beaking a formula, I mean writing a formula in multiple rows, instead of one. Usually, when we write some text, we use…

Vlookup stands for vertical lookup. In other words, vlookup searches for information in a column. If you want to search for information in…

Let’s take a look at the current example. You are traveling the world and there is a list of expenses you made. Each…

With the EXACT and MATCH functions, you can match and compare numbers. This article explains how to use them. Compare two numbers using…

To compare text strings in Excel, you can simply use the comparison operator (=). Comparing strings with EXACT The EXACT function works similarly…

the VLOOKUP function searches for a value in a table you specified. If there is no value it looks for, It returns the…

If you want to split text into columns, you can use Text to Columns Wizard. If you want to have more control over…

If you want to add months to a date, you can use the EDATE function. It returns a date the N months in…