How do I get Null as a result of an if?
 

=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.

How do I get Null as a result of an if?
 

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

How do I get Null as a result of an if?
 

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

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

How do I get Null as a result of an if?
 

=counta() will count anything except cells that are empty. It will include any
formula in the count--no matter what it evaluates to.

Depending on what you're looking for, maybe you could return "", then use a
formula like:
=countif(a:a,"<")



wrote:

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

--

Dave Peterson

How do I get Null as a result of an if?
 

make that formula:

=COUNTIF(A:A,"?*")

Not =countif(a:a,"<")

wrote:

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

--

Dave Peterson

How do I get Null as a result of an if?
 

That's the ticket!!

Normally I'm a java / c# programmer. I'm finding this excel stuff very
limiting. Everything is a bloody hack.




Dave Peterson wrote:
make that formula:

=COUNTIF(A:A,"?*")

Not =countif(a:a,"<")

wrote:

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

--

Dave Peterson