Excel Guides

Returning the Smallest Non-Zero Value in Excel

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.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.