Returns the minimum value of one or more numbers.
Value := Min(Number1, Number2, ...)
If one of the input values is non-numeric, an empty string is returned.
The function description says that if there is a non-number, it outputs a null value. How can I find the minimum value regardless of the null value?
Code: Select all
DistA:= Min(DistA1,DistA2,DistA3,DistA4,DistA5,DistA6,DistA7,DistA8,DistA9)