On Thu, 3 Aug 2006 08:50:14 +1000, "Corey"
wrote:

=IF(AND(C5<"Non U/G",C5<"Delta",C7V2,C7<W2,C8W2),"0.75",IF(AND(C5 ="Delta",C7V2,C7<W2,C8W2),"0.5",IF(AND(C5<"N on U/G",C5<"Delta",C7<V2,C8<V2),"1.5",IF(AND(,C5="Delt a",C7<V2,C8<V2),"1",IF(AND(C5<"Non U/G",C5<"Delta",C7<V2,C8=W2),"0.75",IF(AND(C5="Del ta",C7<V2,C8=W2),"0.5",IF(AND(C5<"Non U/G",C5<"Delta",C7<V2,C8V2,C8<=W2),"0.75",IF(AND(C 7<V2,C8V2,C8<=W2),"0.5","0"))))))))

Sory the actual code with the error is above, I missed a Bracket.
Error is still present though.

From Excel Specifications and limits:

Nested levels of functions 7

You have 8 nested levels.


--ron