Query on Null (#n/a)

M

Mr. Platypus

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.
 
J

John Bundy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF conditions 3
Copy addition formula of non-consecutive horizontal cells 2
Getting text or numerical data from the formula 2
Hyperlinks with lookups 0
Help with calulating Null fields 3
Wildcard issue for Index/Match Function when searching numbers 1
sorting: cleared/null v/s "" 3
match formula 2

Top