Worked out the same solution after posting.
I had a few results that had the same cell value, there fore added an OR and
combined the formulas into fewer IF's and therefore leaving me with more
If's possibilities.

Cheers all who replied.


--
Regards

Corey
"rml" wrote in message
...
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