Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stumped | Excel Discussion (Misc queries) | |||
I'm stumped | Excel Discussion (Misc queries) | |||
I'm Stumped | Excel Discussion (Misc queries) | |||
stumped ?? | Excel Worksheet Functions | |||
Still stumped | Excel Worksheet Functions |