software

Hi, was wondering if can do something for 1 cell greater than a number of
other cells, together instead of separately, such as:

=A1gt;{C1,F1,H1}

nastech wrote:
gt; Hi, was wondering if can do something for 1 cell greater than a
gt; number of other cells, together instead of separately, such as:
gt;
gt; =A1gt;{C1,F1,H1}

Well you can use sumproduct for a range thus:

=SUMPRODUCT((A1gt;C1:H1)*1*(C1:H1lt;gt;quot;quot;))gt;0
Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:=(A1gt;MAX(C1,F1,H1))
--
Gary's Studentquot;nastechquot; wrote:

gt; Hi, was wondering if can do something for 1 cell greater than a number of
gt; other cells, together instead of separately, such as:
gt;
gt; =A1gt;{C1,F1,H1}

Gary''s Student wrote:
gt; Neat trick:
gt;
gt; If A1 is greater than a set of numbers it must be greater than the
gt; max of the set. use:
gt;
gt;
gt; =(A1gt;MAX(C1,F1,H1))
gt;
Why do I so often miss the simple approach and try complicating matters.
Nice one!
thanks, thats great..

quot;Gary''s Studentquot; wrote:

gt; Neat trick:
gt;
gt; If A1 is greater than a set of numbers it must be greater than the max of
gt; the set. use:
gt;
gt;
gt; =(A1gt;MAX(C1,F1,H1))
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, was wondering if can do something for 1 cell greater than a number of
gt; gt; other cells, together instead of separately, such as:
gt; gt;
gt; gt; =A1gt;{C1,F1,H1}

Hi, was wondering if you knew a short cut for this one too: have %change
equation, that adds a cummulative of change for each day, but do not know how
to abbreviate. (must keep original amounts in each column to show direction
up/dn)

(adding separate amounts for each day, for each range selected, such as:
2=(day1 day2),3=(day1 day2 day3)... (thanks)

long verson:
=IF(OR(BS9=quot;quot;,COUNTA(BT9:BX9)=0,MIN(BT9:BX9)=MAX(B T9:BX9)),quot;quot;,
IF(OR($BH$2={quot;quot;,quot;.quot;,2}),(BS9/BT9%-100) (BT9/BU9%-100),IF($BH$2=3,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100),
IF($BH$2=4,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100) (BV9/BW9%-100),
IF($BH$2=5,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100) (BV9/BW9%-100) (BW9/BX9%-100))))))

quot;Gary''s Studentquot; wrote:

gt; Neat trick:
gt;
gt; If A1 is greater than a set of numbers it must be greater than the max of
gt; the set. use:
gt;
gt;
gt; =(A1gt;MAX(C1,F1,H1))
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, was wondering if can do something for 1 cell greater than a number of
gt; gt; other cells, together instead of separately, such as:
gt; gt;
gt; gt; =A1gt;{C1,F1,H1}