Help with Max and Min in eqaution

[bumfart66]

Hi

I know this may be a silly question but I'm trying to understand this formula that shows the next highest value that isn't zero


=MIN(IF(A1:A8>0,A1:A8))

Highest	Lowest	Low but not zero
14,188,126	0	1,213,015
1,774,110	0	50,821
25,404	0	654
229,190	0	37,410
813,340	0	100,890
297,142	0	46,376
104,446	0	22,894

I get the first part that looks for the lowest value, in this case, zero, we say if the value is greater than zero, it's the next part i don't understand, what part of the formula is saying display the next highest value ?

 

[Peter_SSs]

I get the first part that looks for the lowest value, in this case, zero,

No, that isn't quite correct.
=MIN(IF(A1:A8>0,A1:A8))
The formula evaluates the blue part first. The result of that blue part is shown in column C below.
The red part then takes the smallest number that is returned by the blue part (2 in my example)

23 11 30.xlsm
	A	B	C
1	6	2	6
2	0		FALSE
3	2		2
4	0		FALSE
5	7		7
6	0		FALSE
7	0		FALSE
8	22		22
Example

Cell Formulas
Range	Formula
B1	B1	=MIN(IF(A1:A8>0,A1:A8))
C1:C8	C1	=IF(A1:A8>0,A1:A8)
Dynamic array formulas.