software

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

=IF(S9=quot;quot;,quot;quot;,IF(X1=quot;cquot;,AND(AND(A1=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;)),AND(A1=quot;aquot;,B1=quot;bquot;)))

if x=1, then part a amp; 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

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

Can you explain what you're trying to do?

--
Kind regards,

Niek Otten

quot;nastechquot; gt; wrote in message
...
gt; Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
gt; short way. short example:
gt;
gt; =IF(S9=quot;quot;,quot;quot;,IF(X1=quot;cquot;,AND(AND(A1=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;)),AND(A1=quot;aquot;,B1=quot;bquot;)))
gt;
gt; if x=1, then part a amp; b, otherwise, just a. This works, but can't see how
gt; to just do with 2 parts, stead of part a repeated twice. just cannot see
gt; it... Thanks

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=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;))

AND(A1=quot;aquot;,B1=quot;bquot;,C1=quot;cquot;,D1=quot;dquot;)--
DamonLongworth
------------------------------------------------------------------------
DamonLongworth's Profile: www.excelforum.com/member.php...oamp;userid=30711
View this thread: www.excelforum.com/showthread...hreadid=503770yes, 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..

quot;Niek Ottenquot; wrote:

gt; Is this a real example? This formula returns either a blank or TRUE or
gt; FALSE. What does quot;This worksquot; mean? What results did you get?
gt; What does quot;x=1quot; mean? X1=quot;cquot;? What do C1 and D1 have to do with it?
gt;
gt; Can you explain what you're trying to do?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
gt; gt; short way. short example:
gt; gt;
gt; gt; =IF(S9=quot;quot;,quot;quot;,IF(X1=quot;cquot;,AND(AND(A1=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;)),AND(A1=quot;aquot;,B1=quot;bquot;)))
gt; gt;
gt; gt; if x=1, then part a amp; b, otherwise, just a. This works, but can't see how
gt; gt; to just do with 2 parts, stead of part a repeated twice. just cannot see
gt; gt; it... Thanks
gt;
gt;
gt;

anyone home? calls rejected..?

quot;Niek Ottenquot; wrote:

gt; Is this a real example? This formula returns either a blank or TRUE or
gt; FALSE. What does quot;This worksquot; mean? What results did you get?
gt; What does quot;x=1quot; mean? X1=quot;cquot;? What do C1 and D1 have to do with it?
gt;
gt; Can you explain what you're trying to do?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
gt; gt; short way. short example:
gt; gt;
gt; gt; =IF(S9=quot;quot;,quot;quot;,IF(X1=quot;cquot;,AND(AND(A1=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;)),AND(A1=quot;aquot;,B1=quot;bquot;)))
gt; gt;
gt; gt; if x=1, then part a amp; b, otherwise, just a. This works, but can't see how
gt; gt; to just do with 2 parts, stead of part a repeated twice. just cannot see
gt; gt; it... Thanks
gt;
gt;
gt;

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 quot;andquot; basic. Thanks for the input. it is a move
forward.

quot;DamonLongworthquot; wrote:

gt;
gt; I agree. It is difficult to determine what you are trying to accomplish.
gt;
gt;
gt; It seems you could combine your AND statements in the True section of
gt; the second IF:
gt;
gt; AND(AND(A1=quot;aquot;,B1=quot;bquot;),AND( C1=quot;cquot;,D1=quot;dquot;))
gt;
gt; AND(A1=quot;aquot;,B1=quot;bquot;,C1=quot;cquot;,D1=quot;dquot;)
gt;
gt;
gt; --
gt; DamonLongworth
gt; ------------------------------------------------------------------------
gt; DamonLongworth's Profile: www.excelforum.com/member.php...oamp;userid=30711
gt; View this thread: www.excelforum.com/showthread...hreadid=503770
gt;
gt;