# How do you create a formula whose output is a BLANK cell?

• MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

How do you create a formula whose output is a BLANK cell?

Remember a cell whose result is "" is not BLANK.

For example, =ISBLANK(IF(1=1,"","")) results in False.

• I'm looking for any non-VBA formula whose result is a blank cell. What business of Newton's were fallin apples?

• As you've been told elsewhere, you can't.

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• I think in 2016 and 2019, things are different. Am I wrong? Probably. But I won't know for sure until someone convinces me my battle is lost.

• It doesn't seem to be logical, but then Microsoft does a lot of things that don't seem to be logical.

• No one know how to bore a hole in a rod of iron until someone figure it out.