• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 5. Working with Formulas and Functi... > Finding the Smallest Cell Amount (MI...

Finding the Smallest Cell Amount (MIN)

Click the cell in which you want the result of the function to appear (this is called the resultant cell).

Click the down arrow next to the AutoSum button on the Standard toolbar and choose Min from the list that appears.

Excel selects the most obvious range of numbers and puts a dotted line around the cells. Press Enter to accept the range or use the mouse to select alternative cells.

Click the resultant cell to make it the active cell. Notice that the formula is displayed in the Formula bar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint