Thread: stumped
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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