How can I make the Excel MIN function ignore zeros in a set?

Question

In Excel, I have the following formula =(MIN(H69,H52,H35,H18)*(1/H18))*10, which should return the MINrange and divide it by the current cell (* (1 / H18)), and then multiply by 10.

It's hard for me to add a type of NULLIF statement. I want to have (the ability for) empty lines and have the MIN function ignore null / empty fields when choosing the next lowest value (all between 1.0-0.1).

Is there a modifier that I can apply to the MIN function so that it does not compare zeros in the MIN set? Is there a more efficient function than MINto use?

Here is the layout:

• Do not forget to specify the syntax in which it is installed MIN
• H69,H52,H35,H18 , , , . / (. .).
• : , , 2 , 4 , 8 ...

Answer 1

:

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

ctrl + shift + enter, formuala.

Answer 2

=SMALL(A1:A3,COUNTIF(A1:A3,0)+1)