Hi.
I step up here cause I do have the same problem. Can you please inform us if
the contiguous if's can be joined by OR for the the necessary same result
(i.e. in its order as W13 then W14 then (V2-C7)*24) )....
I think you have a sequence of IF's that are constrained by a definite
sequence considering that in the....
1st IF....this contain a definite constraint of C8C7 : RESULT is W13
5th IF....this contain a definite constraint of C7C8 : RESULT is W13
maybe we can add another IF upon your clarification of possible merging by
OR based on agreed constraints vs. RESULT...

"Corey" wrote:

=IF(AND(OR(C5=V13,C5=V15,C5=V16),C8C7,(C8-C7)*24W10,(V2-C7)*24=W13),W13,IF(AND(C5=V14,(V2-C7)*24=W14),W14,IF(AND(OR(C5=V13,C5=V15,C5=V16),C 7<V2,(V2-C7)*24<W13),(V2-C7)*24,IF(AND(C5=V14,C7<V2,(V2-C7)*24<W14),(V2-C7)*24,IF(AND(OR(C5=V13,C5=V15,C5=V16),C7C8,OR(C8 <V2,C8W2)),W13,IF(AND(C5=V14,C7C8,OR(C8<V2,C8W2 )),W14,IF(AND(C7=W2,C5<V9,C5<V10,C5<V11,C5<V1 2,C5<V18,C5<V19,C5<V14),W13,0)))))))

i HAVE APARENTLY RAN OUT OF OPTIONS (7) IN THIS FORMULA.
bUT NEED MORE OPTIONS YET.
iS THER ANYONE WHO HAS THE INTELIGENCE TO LESSEN THE ABOVE FORMULA TO ALLOW FOR YET MORE OPTIONS?

CTM