Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query on Null (#n/a)
I did two MATCH formulas and each column is giving back some null results,
which I expected. I now need to find out if either of the columns has a numerical answer in it (i.e., if there is a number in column A but a null in column B, I want a one. If there are two nulls, I want a zero). SUM doesnt work, IF(OR doesn't seem to work. Any ideas? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
How to write parameter query with "or is null" criteria | New Users to Excel | |||
cell value based on null/not null in another cell | Excel Worksheet Functions |