I would break it down, putting conditions in separate cells and test those.
It's too unwieldy to maintain as is.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" wrote in message
...
=IF(AND(OR(C5=V13,C5=V15,C5=V16),C8C7,(C8-C7)*24W10,(V2-C7)*24=W13),W13,I
F(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)),W 13,IF(AND(C5=V14,C7C8,OR(
C8<V2,C8W2)),W14,IF(AND(C7=W2,C5<V9,C5<V10,C5< V11,C5<V12,C5<V18,C5<V
19,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