formulas Archives | Page 11 of 17

How to Break Formula in Excel

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 the text into columns, you can use Text to Columns Wizard. If you want to have more control…

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

In this lesson, I’ll show you a few ways you can use to count duplicate values in Excel. Some of these formulas are…

The easiest way to convert text to a year in Excel is with the TEXT function. It takes a value as the first…