| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to return a true blank
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Easy formula to return a true or false | Excel Worksheet Functions | |||
| Return blank for true "if" statement when charting, not 0 | Charts and Charting in Excel | |||
| Return blank cell if 'find' statement not true | Excel Worksheet Functions | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Threaded Mode
