Excel Min Function – Smallest value

The Excel MIN (Minimum) function will identify the smallest or minimum number in a range of cells.
Select the cell where in you want the formula to be entered. (Cell B14)
Next Click on the Sigma  ∑ sign.  The drop down menu will give you a choice of functions – select Min.
The formula =Min(number1,[number2]….etc, Select range of cells, hit Enter Key.
Or type the formula =MIN(B2:B13)  in the example shown below.

Excel07 Min

Advertisements
Explore posts in the same categories: Excel - Helpful Hints & Tips

Tags: , , , , , , , , , , , , , , , , , , , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: