MINIMUM VALUE

Let us take an example where we are trying to find the minimum value in a range of cells.

Example 1:

Cell Value
A1 5
A2 8
A3 1
A4 7
A5 10

In example 1, it is clear that among the range of values, the minimum value is found in Cell A3 with the value of 1. Using Excel formula:

=MIN(A1:A5)

This formula would return 1 which is the minimum value in the range selected

Example 2:

Cell Value
A1 5
A2 8
A3 0
A4 7
A5 10

In example 2, it is clear that among the range of values, the minimum value is again found in Cell A3 with the value of 0. But what if, for the purposes of calculating the minimum value, you were to exclude the zeros? If the zero were excluded, the minimum value would no longer be Cell A3 but Cell A1 with the value of 5.

The following formula, to be entered as an array formula (‘CTRL’+’Shift’+’Enter’), will return the value of 5 which basically exclude anything with the value of 0.

{=MIN(IF(A1:A5<>0,A1:A5,FALSE))}

Leave a Reply


*