stumped
 

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,B1 2=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

stumped
 

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
---------------
Jacob Skaria


"LarryK" wrote:

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,B1 2=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

stumped
 

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

"LarryK" wrote:

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,B1 2=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

stumped
 

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


"LarryK" wrote:

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,B1 2=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

stumped
 

Sorry; the below is on a different post..
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"LarryK" wrote:

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,B1 2=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