Excel Guides

Finding the Smallest Even Value in Excel

To find the smallest even value in Excel, you can use the MIN function. This function returns the smallest value in a given range of cells. You can use the MOD function to test if a value is even. The syntax for these functions is as follows:

MIN(range)

MOD(number, 2)

To find the smallest even value in a range of cells, you can use the following formula:

=MIN(IF(MOD(range,2)=0, 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.