I agree. It is difficult to determine what you are trying to accomplish.
It seems you could combine your AND statements in the True section of
the second IF:
AND(AND(A1="a",B1="b"),AND( C1="c",D1="d"))
AND(A1="a",B1="b",C1="c",D1="d")
--
DamonLongworth
------------------------------------------------------------------------
DamonLongworth's Profile:
http://www.excelforum.com/member.php...o&userid=30711
View this thread:
http://www.excelforum.com/showthread...hreadid=503770