Minimum


show more Minimum provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Minimum

Another commonly used function is the Minimum function. And what that will do is it will go through an array of numbers, and it will pick out the smallest value that it finds. If you scroll down to the bottom of your Inventory15 spreadsheet, you'll see that I've added a row for minimum cost. Again, we'll review how you work with functions. You select the cell where the function answer is going to be presented, you go up to your Function Library to find the function you want to work with, so you click on it, and you pick the function that you're looking. Now I knew that the Minimum function was underneath the AutoSum, so I select that, and it identifies for me, what array of cells is going to look through to find the minimum value. Now, in this case, what it's doing is it's defaulting directly above it, until it finds the next empty row, or the first empty cell. And so it's going to stop just two rows ahead of me. Now, I don't want the minimum between this particu...

Minimum
Video duration: 3m 55s 5h 13m Beginner

Viewers:

Minimum provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...