If formula maxed out to 7, but need 1 more. Help ???

[Corey]

=IF(OR(AND(AB16=FALSE,AC16>AB7,AB7<>0,AC7<>0,AC20<>0,AC20+AC7>Y10,C8<W2),
AND(AB16=FALSE,AC16>AB7,AB7<>0,AC7<>0,AC20<>0,AC20+AC7<=Y10,(C8-C7)*24<W10)),AC7,
IF(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8>C7,C7>W2,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8>C7,C7>W2,AB16=FALSE,(C8-C7)*24>=Y10),
ANDAB16=FALSE,C7>C8,C5<>V9,C5<>V10,C5<>V11,C5<>V12,C5<>V18,C5<>V19,(C8-C7+(C7>C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7>C8,(C8-C7+(C7>C8))*24>W10,C5<>V12),AC7-AC20, <=========
This If needs to have the result as (AC7-AC20)
IF(AND(AC7<>0,AC20<>0,(C8-C7)*24>W10),AC7-AC20,
IF(AND(AC7<>0,C5<>V9,C5<>V10,C5<>V11,C5<>V12,C5<>V18,C5<>V19,AC9<>0,AC10<>0,AC11=0,AC12=0),AC7-(AC9+AC10),
IF(AND(AB16=FALSE,(C8-C7)*24=W10,AC7<>0,AC11=AC20),AC7-AC11,0)))))))


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

=IF(OR(AND(AB16=FALSE,AC16>AB7,AB7<>0,AC7<>0,AC20<>0,AC20+AC7>Y10,C8<W2),
AND(AB16=FALSE,AC16>AB7,AB7<>0,AC7<>0,AC20<>0,AC20+AC7<=Y10,(C8-C7)*24<W10)),AC7,
IF(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8>C7,C7>W2,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8>C7,C7>W2,AB16=FALSE,(C8-C7)*24>=Y10),
AND(AB16=FALSE,C7>C8,C5<>V9,C5<>V10,C5<>V11,C5<>V12,C5<>V18,C5<>V19,(C8-C7+(C7>C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7>C8,(C8-C7+(C7>C8))*24>W10,C5<>V12),AC7, <======== Yet
the same If result from above needs to be also on accasions (AC7) without
the (-AC20)
IF(AND(AC7<>0,AC20<>0,(C8-C7)*24>W10),AC7-AC20,
IF(AND(AC7<>0,C5<>V9,C5<>V10,C5<>V11,C5<>V12,C5<>V18,C5<>V19,AC9<>0,AC10<>0,AC11=0,AC12=0),AC7-(AC9+AC10),
IF(AND(AB16=FALSE,(C8-C7)*24=W10,AC7<>0,AC11=AC20),AC7-AC11,0)))))))

Above is the same formula but with each result needed.

I was wondering if someone could have a look at it for me to see if i can
cut or modify this formula so it will allow me to add another result. ??

I can add a ((c8-c7+(c7>c8))*24<w10+y10) option into the top IF highlighted
line, but then i need to add the bottom senario without that extra bit.

Any idea's

Regards

Corey

 

[Guest]

Check here
http://www.cpearson.com/excel/nested.htm

Also note Logical tests can usually be replaced w/multiplication or addition
(TRUE = 1, and FALSE = 0)
=IF(0, TRUE, FALSE) would process the FALSE condition. Any nonzero number
will result in IF processing the TRUE condition.

So
=IF(AND(AB16=FALSE,AC16>AB7,AB7<>0,AC7<>0,AC20<>0,AC20+AC7>Y10,C8<W2), TRUE,
FALSE)

could be expressed
=IF((AB16=FALSE)*(AC16>AB7)*(AB7<>0)*(AC7<>0)*(AC20<>0)*((AC20+AC7)>Y10)*(C8<W2), TRUE, FALSE)

saving a level by eliminating the AND function call