yes, sorry, assume all items = true, except for X as a toggle. then had to
use 1 leg of a1,b1 twice in formula, when they are the exact same item. as a
wasted space question. good? real formula is way less descriptive / takes
up megabytes..

"Niek Otten" wrote:

Is this a real example? This formula returns either a blank or TRUE or
FALSE. What does "This works" mean? What results did you get?
What does "x=1" mean? X1="c"? What do C1 and D1 have to do with it?

Can you explain what you're trying to do?

--
Kind regards,

Niek Otten

"nastech" wrote in message
...
Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
short way. short example:

=IF(S9="","",IF(X1="c",AND(AND(A1="a",B1="b"),AND( C1="c",D1="d")),AND(A1="a",B1="b")))

if x=1, then part a & b, otherwise, just a. This works, but can't see how
to just do with 2 parts, stead of part a repeated twice. just cannot see
it... Thanks