Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i assign a null value to a cell in Microsoft Excel?
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 @ Thanks a lot in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i assign a null value to a cell in Microsoft Excel?
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 "vkrishna_anne" wrote: 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 @ Thanks a lot in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set the contents of cell to Null in Excel 2007? | Excel Worksheet Functions | |||
how do i assign a range of numbers to a cell in excel | Excel Discussion (Misc queries) | |||
How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) |