My logic is is illogical, apparently.

Okay, so I have a formula that is meant to go to the fist instance of contiguous text value in column K, take the corresponding date from column L, and subtract that from the final corresponding date from column M, then display that ammount in column O. All other values for column O, with identical contiguous values for column K should be "0". The idea is to give a number of days from the first date for a person, to the last date listed. For some reason, the result of the formula in O16 (regardless of what order I apply the logic) continues to be the same as if the formula reads =M16-L15. The way I wrote and read this formula, the logic looks sound to me, but it just is working the way I think it should.

In any case, here is the formula for O16

=M16-(IF(K16=K17,M16,(IF(K16=K15=K14=K13=K12=K11,L11,(IF(AND(NOT(K16=K11),K16=K15=K14=K13=K12),L12,(IF(AND(NOT(K16=K12=K11),K16=K15=K14=K13),L13,(IF(AND(NOT(K16=K13=K12=K11),K16=K15=K14),L14,(IF(AND(NOT(K16=K14=K13=K12=K11),K16=K15),L15,L16))))))))))))

Here is what is looks like:
Capture.PNG

Can anyone tell me why this isn't working? Making it work will save me 64,000 lines of review. Seriously. Thank You.

Noso,

First off, in your IF statements, your conditions cannot be K16=K15=K14=K13=K12=K11, you can only have one equal sign at a time... you can do something like... AND(K16=K15,K16=K14,K16=K13, etc.)

Secondly, if I understand you... for O16, it should equal M16-L14... correct?

Yes, thanks, that's the goal. I'm trying to find overall period for travel by individuals, from the first day.

The IF statement conditions were a little confusing, as when I did a test to see if the mutiple ='s would work, I did this: Capture2.PNG, which seems to work. Is this something that happens when you nestle logic?

Thanks!

Excellent. You've fixed the issue, it seems. THANKS!!!