If smallest number is equal to

This tutorial shows how to test if the smallest number from a range of cells is equal to a specific number and return a value if the test is True or False through the use of an Excel formula, with the IF and MIN functions

EXCEL FORMULA 1. If smallest number is equal to

EXCEL

Hard coded formula
If smallest number is equal to
Cell reference formula
If smallest number is equal to
=IF(MIN(B5:B9)=300,"Include","Exclude")
=IF(MIN(B10:B14)=C5,C6,C7)
GENERIC FORMULA

=IF(MIN(range)=number,value_if_true,value_if_false)

ARGUMENTS
number: A number that you want to test a range against for being equal to the smallest number in that range.
range: A range that contains the numbers in which you want to identify the smallest number.
value_if_true: Value to be returned if the smallest number in the range that is being tested is equal to a specified number.
value_if_false: Value to be returned if the smallest number in the range that is being tested is not equal to a specified number.

GENERIC FORMULA

=IF(MIN(range)=number,value_if_true,value_if_false)

ARGUMENTS
number: A number that you want to test a range against for being equal to the smallest number in that range.
range: A range that contains the numbers in which you want to identify the smallest number.
value_if_true: Value to be returned if the smallest number in the range that is being tested is equal to a specified number.
value_if_false: Value to be returned if the smallest number in the range that is being tested is not equal to a specified number.

EXPLANATION

This formula uses the IF and MIN functions to test if the smallest number in a range is equal to a specific number and return a value if the test is True or False.
Click on either the Hard Coded or Cell Reference button to view the formula that has the number that you want to test the range against for being equal to the smallest number in the range and the return values directly entered into the formula or referenced to a specific cell.

In this example the formula initially identifies the smallest number in range B5 to B9 (hard coded example) or B10 to B14 (cell reference example), which is -70. Then the formula performs a test to identify if smallest number in the range is equal to 300 and return a text value of "Include" otherwise it will return a text value of "Exclude". In this example given that the smallest number in the range doesn't equal to 300 the formula will return a text value of "Exclude".

RELATED TOPICS

Related Topic Description Related Topic and Description
How to test if the smallest number from a range of cells is less than or equal to a specific number and return a value if the test is True or False
How to test if the smallest number from a range of cells is greater than or equal to a specific number and return a value if the test is True or False
How to test if the smallest number from a range of cells is greater than a specific number and return a value if the test is True or False

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
The Excel IF function performs a test on specified conditions entered into the formula and returns a specified value if the result is TRUE or another specified value if the result is FALSE
The Excel MIN function returns the smallest value from a specified range of numeric values