Minimum value

  • Post author:
  • Post category:Uncategorized

If you have a set of data or numbers and you want to get a minimum value in excel, the MIN function would be the perfect formula. The applicant of the function or the formula is straightforward.

Generic Formula:

=MIN(range)

Example Application

The best application example of this formula is a classroom set up. Assuming you are a teacher, and you have a list of students’ result in particular papers. How do you get minimum value in excel? MIN is the best function to work with. Check out this example:

Figure 1. Example 1 of MIN Function

From this example, the formula in H6:

=MIN(C6:F6)