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.