Min 0. That is min 1 blank returns 0 and min 1 blank returns 1. Arguments can be provided as numbers names arrays or references that contain numbers.
The min function ignores true and false values and numbers entered as text unless they are typed directly into the list of arguments. If either expression returns a value which is not allowed min returns an error. The min function in current versions of excel accepts up to 255 arguments.
If we assume your numbers are in a1 a100 you would simply use the min formula like shown below.
This article will show you method of finding minimum value excluding zero in excel. Normally zero value is supposed to be the minimum value among positive numbers. Find minimum value excluding zero with formula. Excel has a built in formula function that makes finding the minimum value in a range of cells easy.
