stumped

[LarryK]

I need to combine a formula

=IF(AND(B11=10,B12=13),"NO","YES") FOMULA WORKS UNTIL I ADD THE FOLLOWING
AND THE FORMULA LOOKS LIKE THIS

=IF(AND(B11=10,B12=13),"NO","YES",IF(AND(B11=14,B12=15),"MEET","SEAT"))

How would I combine the two with out errors, I seem to missing something? If
I use the same formula not using the (and) it works fine. I'm stump.

many thanks for any help I could get!

Larry

 

[Jacob Skaria]

Please let us know more about the format of the file.

One of the reasons would be the text file may not be separated with a vbCRLF
but only with vbLF

If this post helps click Yes

 

[Sheeloo]

Try
=IF(AND(B11=10,B12=13),"NO",IF(AND(B11=14,B12=15),"MEET","SEAT"))

I am assuming you want to get the result of
=IF(AND(B11=10,B12=13),"NO",IF(AND(B11=14,B12=15),"MEET","SEAT"))

when
AND(B11=10,B12=13) is not TRUE

 

[Jacob Skaria]

Please clarify.

If you are looking to apply the second IF condition only if the first
condition returns true; then replace the TRUE with second IF condition.

If this post helps click Yes

 

[Jacob Skaria]

Sorry; the below is on a different post..