When working with Excel formulas, a common term is “empty string”.

A text string is atext valuelike “apple”.

An empty string is a text value that has no value.

If the value is greater than 10, the formula returns “x” as text.

Otherwise, IF returns an empty string ("").

When an empty string is the result of a formula, it looks like the cell is blank.

So, empty strings are commonly used to return a value that looks like nothing.

In other words, return a result that appears as an empty cell.

One thing to note is that some functions will treat empty strings as if they do have a value.

Likewise, theCOUNTA functionwill include cells that contain formulas that have returned “”.