Cell > than number of other cells..

N

nastech

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

=A1>{C1,F1,H1}
 
P

Paul Lautman

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

=A1>{C1,F1,H1}
Click to expand...

Well you can use sumproduct for a range thus:

=SUMPRODUCT((A1>C1:H1)*1*(C1:H1<>""))>0
 
G

Gary''s Student

Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:


=(A1>MAX(C1,F1,H1))
 
P

Paul Lautman

Gary''s Student said:
Neat trick:

If A1 is greater than a set of numbers it must be greater than the
max of the set. use:


=(A1>MAX(C1,F1,H1))
Click to expand...
Why do I so often miss the simple approach and try complicating matters.
Nice one!
 
N

nastech

thanks, thats great..

Gary''s Student said:
Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:


=(A1>MAX(C1,F1,H1))
Click to expand...
 
N

nastech

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="",COUNTA(BT9:BX9)=0,MIN(BT9:BX9)=MAX(BT9:BX9)),"",
IF(OR($BH$2={"",".",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))))))
 
Top