| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Query on Null (#n/a)
if the result is N/A you can test for it with
if(isna(formula),formulaIfNA,FormulaIfNotNa) you can add on to the nesting to test the other as well. -- -John Please rate when your question is answered to help us and others know what is helpful. "Mr. Platypus" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
