Category: formulas

In this article, I’ll present how you can extract or remove the text before and after a character. In the later part, there…

To convert a standard date to month and year, you can use the TEXT function. This function converts a value to text in…

With the COUNTIF function, you can count the number of cells that meet a single condition. The following example contains a list of…

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…