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

=IF(OR(AND(AB16=FALSE,AC16AB7,AB7<0,AC7<0,AC20< 0,AC20+AC7Y10,C8<W2),
AND(AB16=FALSE,AC16AB7,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),C8C7,C7W2 ,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8C7,C7 W2,AB16=FALSE,(C8-C7)*24=Y10),
ANDAB16=FALSE,C7C8,C5<V9,C5<V10,C5<V11,C5<V12 ,C5<V18,C5<V19,(C8-C7+(C7C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7C8,(C8-C7+(C7C8))*24W10,C5<V12),AC7-AC20, <=========
This If needs to have the result as (AC7-AC20)
IF(AND(AC7<0,AC20<0,(C8-C7)*24W10),AC7-AC20,
IF(AND(AC7<0,C5<V9,C5<V10,C5<V11,C5<V12,C5<V 18,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,AC16AB7,AB7<0,AC7<0,AC20< 0,AC20+AC7Y10,C8<W2),
AND(AB16=FALSE,AC16AB7,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),C8C7,C7W2 ,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8C7,C7 W2,AB16=FALSE,(C8-C7)*24=Y10),
AND(AB16=FALSE,C7C8,C5<V9,C5<V10,C5<V11,C5<V1 2,C5<V18,C5<V19,(C8-C7+(C7C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7C8,(C8-C7+(C7C8))*24W10,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)*24W10),AC7-AC20,
IF(AND(AC7<0,C5<V9,C5<V10,C5<V11,C5<V12,C5<V 18,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+(c7c8))*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

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

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,AC16AB7,AB7<0,AC7<0,AC20<0, AC20+AC7Y10,C8<W2), TRUE,
FALSE)

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

saving a level by eliminating the AND function call



"Corey" wrote:

=IF(OR(AND(AB16=FALSE,AC16AB7,AB7<0,AC7<0,AC20< 0,AC20+AC7Y10,C8<W2),
AND(AB16=FALSE,AC16AB7,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),C8C7,C7W2 ,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8C7,C7 W2,AB16=FALSE,(C8-C7)*24=Y10),
ANDAB16=FALSE,C7C8,C5<V9,C5<V10,C5<V11,C5<V12 ,C5<V18,C5<V19,(C8-C7+(C7C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7C8,(C8-C7+(C7C8))*24W10,C5<V12),AC7-AC20, <=========
This If needs to have the result as (AC7-AC20)
IF(AND(AC7<0,AC20<0,(C8-C7)*24W10),AC7-AC20,
IF(AND(AC7<0,C5<V9,C5<V10,C5<V11,C5<V12,C5<V 18,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,AC16AB7,AB7<0,AC7<0,AC20< 0,AC20+AC7Y10,C8<W2),
AND(AB16=FALSE,AC16AB7,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),C8C7,C7W2 ,(C8-C7)*24<=Y10),(C8-C7)*24-AC19,
IF(OR(AND(OR(C5=V13,C5=V14,C5=V15,C5=V16),C8C7,C7 W2,AB16=FALSE,(C8-C7)*24=Y10),
AND(AB16=FALSE,C7C8,C5<V9,C5<V10,C5<V11,C5<V1 2,C5<V18,C5<V19,(C8-C7+(C7C8))*24<=Y10)),AC7-AC20,
IF(AND(AB16=TRUE,C7C8,(C8-C7+(C7C8))*24W10,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)*24W10),AC7-AC20,
IF(AND(AC7<0,C5<V9,C5<V10,C5<V11,C5<V12,C5<V 18,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+(c7c8))*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