In this Excel Tutorial I will show you how to use Database Min Function using Excel 2010.
For purpose of this Tutorial I will use Packing slip Template.
Database Min Function is looking for the lowest value base on Criteria. I will show base on the example.
In my example I am looking for the lowest price for 150 flowers or more. To do that I will go to Formula bar - type equal, DMIN and insert function (fx)
In Function Argument window I go to Database and select my table - including headers.
Next I type the Field where I will find the price.
I select last Criteria from the top. As you can see Quantity is - below or equal one hundred fifty. I click OK.
Dmin Function show me 140. This is the correct result.
You can find Dmin Function if you go to Formulas tab and select Insert Function. In select category I choose Database function and below DMIN function. Click OK to finish.
Now I can see that I get the same Function Arguments window.
I hope this Excel Tutorial was helpful.
Katie and Emil.