Thanks for the reply guys,
So what options do i have if there is too many nestings?
Is there a different formula syntax i can use?


--
Regards

Corey
"Greg Wilson" wrote in message
...
You have one too many nesting levels at eight and also, you either have an
unintended comma or are missing a condition in the following And function:

IF(AND(,C5="Delta",C7<V2,C8<V2).

Note that this will always return False as currently written:

Regards,
Greg

"Corey" wrote:

I am getting an error in this formula:

=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"))))))))

Can anyone tell me why?

If i change it by dropping off the last bit(but is needed) the error is
not present:

=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","0"))))) ))


Is it becase it has reached the limit of the Formula?
Is there a way to simplify the above?


Regards

Corey