thankyou, that is a good point, looks like can save alittle space. may be a
silly question because don't know if there was an answer, for removing a
repeated variable. (knew what was what on this type of question, to get an
answer have to put in simple terms, because it was extra) been there, irrel
details get no response. thankyou. just find repeat of math terms to be
unacceptable is all. abcd "and" basic. Thanks for the input. it is a move
forward.

"DamonLongworth" wrote:


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