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

gfr92y · Oct 10th 2021

[xpost][/xpost]

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

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

**alansidman** · Oct 10th 2021

Please explain in simple English what you are trying to prove because your formula does not make sense to me.

gfr92y · Oct 10th 2021

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

**rory** · Oct 10th 2021

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

gfr92y · Oct 10th 2021

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.

**royUK** · Oct 10th 2021

I'm sure that if Rory says you cannot do this then it cannot be done.

gfr92y · Oct 10th 2021

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

gfr92y · Oct 10th 2021

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

Participate now!