Formula to return a true blank

D

dcwood57

Is there a way for a formula to return a true blank?

I'm trying to do a query, for either DCountA or SumProduct, that refers to
another cell for the criteria. I wish to have that criteria ignored if it is
blank.

=If(Isblank(j4),"",j4) -- doesn't do the job because "" actually returns an
empty string rather than a true blank. "" is not treated the same as a true
blank in criteria ranges.

The reason I'm trying to do this is that I'm trying to do several (actually
24) queries based upon selections from dropdown lists.
 
P

Pete_UK

No, a formula cannot return a true blank, because the cell contains
the formula !!

Have you tried something like this:

=IF(j4="","",j4)

Hope this helps.

Pete
 
D

dcwood57

I think that this:

is the problem. It doesn't matter what formula I put in, the criteria range
will not be blank. I've been looking for a solution for this for quite a
while. I'm afraid that the solution is not to be found without programming.
I may write a VBA script to do what I'm trying to do. Or perhaps learn more
about Access Report writing as the database that I'm querying is an Access DB
anyway.

Thanks for your help.

Don
 
I

ilia

Instead of ISBLANK(J4) use LEN(J4)=0.


I think that this:


is the problem. It doesn't matter what formula I put in, the criteria range
will not be blank. I've been looking for a solution for this for quite a
while. I'm afraid that the solution is not to be found without programming.
I may write a VBA script to do what I'm trying to do. Or perhaps learn more
about Access Report writing as the database that I'm querying is an Access DB
anyway.

Thanks for your help.

Don






- Show quoted text -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top