MIN function in array formula

  • Thread starter Thread starter Andre Croteau
  • Start date Start date
A

Andre Croteau

Hello,

I have created an array formula with a MAX array formula with 2 criteria,
which works fine.
However, when I change the function to MIN, I always get the result 0.

this works fine: {max((a2:a20=1)*(b2:b20=2)*c2:c20)} result gives 75

But this one doesnt:: {min((a2:a20=1)*(b2:b20=2)*c2:c20)} result gives 0,
but it should give 19

A B C
1 1 2 50
2 1 2 75
3 1 3 99
4 2 2 15
5 1 2 19
etc


Can anyone help??
Thanks in advance

André
 
You formula *should* give 0, since multiplying FALSE (the result of
(A2:A20=1) when the value <> 1) by a value returns 0.

One way (array entered):

=MIN(IF((A1:A20=1)*(B1:B20=2),C1:C20,""))
 
Back
Top