From A1 to A6:
4,0,5,1,2,3
Code:
=MIN(IF($A$1:$A$6<>0,IF($A$1:$A$6<>1,$A$1:$A$6)))
This formula, with the use of nested IF, works. (Return: 2)
Code:
=MIN(IF(AND($A$1:$A$6<>0,$A$1:$A$6<>1),$A$1:$A$6))
This formula, with the use of AND inside IF, does not work. (Return: 0)
I'd like to ask how to make the second formula (use of AND) works.
Many thanks!