#N/A Getting Rid Of (Easy One)

[SamBo1234]

Hello All,

Cant seem to work this one out and wondered if you guys can help.

I have the following formula in Cell C1

=IF(AND(A1="TRUE",B1="TRUE"),"Yes","No")

Some of my results show as #N/A, and i would like to add to the formula so my results will not show as the #N/A when the references cells have no data in.

I have tryed ISNA, NOT but cant seem to get it lol

Please help.

Cheers All.

 

[mbb4331]

Something like this:

=IF(OR(ISNA(A1),ISNA(B1)),"",IF(AND(A1="TRUE",B1="TRUE"),"Yes","No"))

 

[onlyadrafter]

Hello,

are A1 and B1 formulas? If so, what are they?

You could try

=IF(ISERROR(OR(A1,B1)),"",IF(AND(A1=TRUE,B1=TRUE),"Yes","No"))

 

[Fergus]

try: =IF(ISNA(OR(A1="TRUE",B1="TRUE")),"No data",IF(AND(A1="TRUE",B1="TRUE"),"Yes","No")) not tested but I think the brackets are right

 

[SamBo1234]

A1:A20 has simply "TRUE" or "FALSE" in
B1:B20 has simply "TRUE" or "FALSE" in

So in C1:C20 i did the formula above to check see of both Matched "TRUE", If so Display a "Yes" or If not Display a "No".

Some however return #N/A values as come cells in A1:A20 and B1:B20 have no data in. I would like to get rid of them

 

[SamBo1234]

A1:A20 has simply "TRUE" or "FALSE" in
B1:B20 has simply "TRUE" or "FALSE" in

So in C1:C20 i did the formula above to check see of both Matched "TRUE", If so Display a "Yes" or If not Display a "No".

Some however return #N/A values as come cells in A1:A20 and B1:B20 have no data in. I would like to get rid of them

 

[mbb4331]

So columns A and B can contain "True", "False" or blank.

Is this correct?

If A is blank and B is True, what should C be?

 

[SamBo1234]

So columns A and B can contain "True", "False" or blank.

Is this correct?

If A is blank and B is True, what should C be?

Yes you are correct, A and B contain "True", "False", or are simply Blank statements.

Column C i would like to return "Yes" if A1 and B1 Match "True", return a "No" if they do not Match "True", and if there is no data in A1 or B1 for example then rather than the formula returning a #N/A it would simply just return a BLANK.

I think i can work it out from your posts ill give it a whirl. Thanks

 

[Fergus]

How are columns A & B formatted, as text or general. Be careful when you use the words TRUE or FALSE as these have special meanings. What happens when you just type true, just like that, in lower case, into column A or B does it come out as TRUE?

 

[SamBo1234]

Thanks Guys,

Just tryed

=IF(OR(ISNA(A1),ISNA(B1)),"",IF(AND(A1="TRUE",B1="TRUE"),"Yes","No"))

Works like i want TY allz.