Re: smaller equations: a & b, or just a..

060129: smaller equations: a & b, or just a..
Thanks-all ! ! These answers all look good, and should all be right, as was
wondering about use of true/false in equations, and have not tried any of
them yet. (particular version my application the only choice left)

sorry if I left anything out I could have included, thought of the
following, but it may not matter? long-legs includes tests of same item from
mulitple locations, placed in a conditional format (for which this question
surrounds). For items that I "have" to test, the space required of 257/258
characters was a constraint. Thanks.


"Dana DeLouis" wrote:

> > trying to get rid of using a=c twice
>
> I think if you factor out a=c, it reduces to this:
>
> =AND(a=c,OR(b=c, $ab$2<>"x") )
>
> Hope I got it right :>)
> --
> HTH. :>)
> Dana DeLouis
> Windows XP, Office 2003
>
>
> "nastech" <nastech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:5D808BED-6202-4340-AB79-142898D49D32@xxxxxxxxxxxxxxxx
> > don't know it this can work, but
> > i have working, long equations that break down into basically 3parts:
> > If switch is set, then a & b, else just a. That is a repetition I am
> > trying
> > to get rid of.
> >
> > basically have: =IF($ab$2="x",AND(A=C,B=C),A=C)
> >
> > trying to get rid of using a=c twice, thanks..
> > (a can stand alone, but b must be anded with a)
> > maybe something like:
> > =AND(A=C,IF($ab$2="x",b=c)) but 2nd part comes up as false, so not work..
> > =AND(A=C,IF($ab$2<>"x","",b=c)
> >
> >
>
>
>
.