If formulas with #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need an if formula or similar which will look at the values in columns A
and B and bring back the results as shown. I can't seem to cover all
scenarios.

Thanks,

Esther
A B Result

1 X Y Check
2 X X X
3 #N/A #N/A Check
4 #N/A X X
5 Y #N/A Y
 
=IF(AND(ISNA(A1),ISNA(B1)),"Check",IF(ISNA(A1),B1,IF(ISNA(B1),A1,IF(A1=B1,A1
,"Check"))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Excel Help with dates 2
Scrabble Value calculation for Welsh words 0
Formula to return a formula 1
Counting with multible conditions in a table 8
% of subtotal in pivot table 1
IF/VLOOKUP with #N/A results 6
Convert multiple columns into on column? 3
Need a formula 6

Back
Top