Thread: Quick/easy Question: Blank cell vs =""

is there anyway for a formula to output a blank cell.
For example what I use is
If(a1=5,a1,"")

But ="" is not a blank cell, meaning IsBlank("") = false

Is there anyway to write that If() formula to output a Blank cell rather than a cell with an empty text string?

Thanks

In short, no - a cell containing a formula must contain something (even if Null).

As you point out ISBLANK, COUNTA etc treat Nulls as non-blanks (0 length text string), COUNTBLANK however does not, ie

=COUNTBLANK(B1)

will return 0 where B1 contains either Blank / Null.