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))
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 ?
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 ?