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

[gfr92y]

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.

[Logit]

Here is a resource with an EXTENSIVE discussion of the goal :

https://stackoverflow.com/questions/...rmula-in-excel

[JoePublic]

Cross-posted here: https://www.ozgrid.com/forum/index.p...-a-blank-cell/

Please take a minute to read the forum rules and follow them in future. Thank you.