< Go Back

Smaller of two values

Want to learn how to get smaller, or lesser, of two values? This post will give you an overview of how to do so using the MIN function in Excel.

To get smaller, or lesser of two values using the MIN function, you can use and follow the procedure below:

  • Select cells on the right of the row you are interested in on the spreadsheet
  • Click on the Formulas tab on the menu bar.
  • On Function Library group, click Insert Function.
  • Press Delete to delete the content of the Search for a function text box.

Example 1

The dialogue box will display as shown below.

Figure 1. How to access MIN formula in Excel

  • Type Min and click OK.

Example 2

It will display a dialogue box

Figure 2. Smaller of two values

  • The number1 is the span of cells to which you want to apply the formula or cell numbers for which you want the maximum. In the example above, it is E4 to F4. Type E4:F4.
  • Click on OK.
  • The result is provided in cell G4

It will show you the result displayed in the screenshot below:

Figure 3. The result displayed by MIN

Interpretation of the Result

What is displayed above shows that in the row extending from E4 to F4 in the spreadsheet above, the MIN function is used to get the smaller or lesser value of the numbers, that is,

=MIN(E4,F4)

‘3’ in G4 is return as the result because it is smaller than ‘4’. It can be easily verified by looking at the smaller number in each cell from the data provided.

On the other hand, simply type the formula above into the cell on the right of the row you are keen on. Hit the enter key when you are done typing, this automatically returns the smallest value in the number provided in the cells.

IF can also be used to get the smaller of two values. Consider the example displayed on the screenshot below in which the formula in G9 is:

=IF(E9<=F9,E9,F9)

Figure 4. Return smaller of two values.

In this case, the formula for G9 indicates that the value in E9 should be returned IF lesser than or equals to the value in F9, since this is not true, the value in F9 is returned.

This is the way this formula does it

What the IF formula does essentially is to check the cells that have values that are smaller, using the following formula

=IF(E9<=F9,value1,value2)

the cells you want to calculate for. It will return the value in F9 if the condition is not true.

Nonetheless, the MIN function is faster and saver to use as it contains no repetitive references, so it is less inclined to blunders.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar