How do I get Null as a result of an if?
I want something that counta() won't pick up.
There is nothing!
There is no "null", no "nil", no "nothing" !
You might be able to do something with an event macro but I can't help with
that.
What are you trying to do? There may be a workaround.
Biff
wrote in message
oups.com...
Let me rephrase then.
I want something that counta() won't pick up.
Biff wrote:
wrote..
=if(false, "yup",) will record 0
=if(false, "yup","") will record the empty string
=if(false, "yup") will record "False"
What I want is null, nothing, nada. rien de tout, a virgin cell.
Well, you ain't gonna get it!
There is no "null". The closest you can get is the empty string
Biff
|