The Smallest Non-Zero Value function in Excel returns the smallest positive value that is greater than zero. This function is useful for finding the lowest positive value in a range of cells. The function is entered as follows:
=SMALLESTNONZERO(value1,value2,...)
The values can be numbers, cell references, or ranges of cells. If no values are entered, the function will return the #VALUE! error value.
To use the Smallest Non-Zero Value function, enter the values for which you want to find the smallest non-zero value. For example, if you have a range of cells that contains numbers between -10 and 10, and you want to find the smallest positive number in that range, you would enter the following:
=SMALLESTNONZERO(-10,10)
The function will return the value 1, which is the smallest positive number in the range.