How do i assign a null value to a cell in Microsoft Excel?

[vkrishna_anne]

All,
I need to use DSUM functions with the criteria values to be generated by
Formulae. In this process I need some of the fields in the criteria to be
Null so that DSUM picks up all possible values for these fields.

Since these criteria fields are generated by formulae, I need to be able to
assign a Null value using a formula. However I am unable to do it. I tried
different ways (trying a NA() in the IF formula, creating a space and
trimming it etc.) I really appreicate if someone can help me with this. If
you need more clarifications regarding this query, ping me @
(e-mail address removed)

Thanks a lot in advance

 

[Duke Carey]

Null is a concept that Excel hasn't incorporated. If you have a formula in a
cell, by definition that cell cannot be blank or have a NULL value.

Since you understand NULL, it seems you know something of databases.

You will save yourself some heartache by doing database oriented analysis in
Access or, if you don't have Access, downloading SQL Server Express