Excel Guides

How to Return a Blank Value in Excel

There are a few ways to return a blank value in Excel. The most common way is to use the empty string "".

Another way is to use a space character. To do this, type a space before the equal sign when you enter the formula.

You can also use the null value, which is represented by two double quotes (""").

If you want to return a blank cell, you can use the ISBLANK function. This function returns TRUE if the cell is blank, and FALSE if it is not blank.

You can also use the IF function to return a blank cell. The syntax for this function is:

=IF(condition, value_if_true, value_if_false) 

For example, the following formula will return a blank cell if the value in cell A1 is less than 100:

=IF(A1<100, "", "") 

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.