|Besides my question about the formula that always returns No, I think I see another problem:|
Let's look at 2 cases where the formulas will return "Possibly"
AND(G36=J43,G37=J43) ---> Possibly
AND(G36=J44,G37=J43) ---> Possibly
Now, since G36 and G37 can only contain Yes or No because of the formulas that are in them, let's put No in J43 and J44, so that both of those IF(ANDs return 'Possibly"
G36 = J43 = No AND G37 = J43 = No ---> Possibly
G36 = J44 = No AND G37 = J43 = No ---> Possibly
OK, so here's the other case where you want the combined formula to return Possibly:
In this case, the AND portion must be FALSE in order to get Possibly, which means that one of those pairs has to be FALSE. However, since we put No in all of those cells, that formula is going to return No.
G36 = J43 = No AND G37 = J44 = No ---> No
In other words, I don't see how you can combine all of the formulas when the same set of circumstances returns 2 different values when formulas are used separetly.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.