Home Computer Learn Database Formula Dmin Excel formula How to use

Learn Database Formula Dmin Excel formula How to use

2 min read
0
0
136
1ST.2 1

DMIN

Learn Dmin Excel formula How to Use

 

What Does It Do ?
This function examines a list of information and produces smallest value from a specified column.

Syntax
=DMIN(DatabaseRange,FieldName,CriteriaRange)

The DatabaseRange is the entire list of information you need to examine, including the
field names at the top of the columns.

The FieldName is the name, or cell, of the values to pick the Min from, such as “Value Of Stock” or I3.

The CriteriaRange is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.

The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.

Formatting
No special formatting is needed.

Examples
The lowest Value Of Stock of a particular Product of a particular Brand.

Dmin Excel formula Example-1

The lowest Value Of Stock of a Bulb equal to a particular Wattage.

Dmin Excel Formula -2

 

The lowest Value Of Stock of a Bulb between two Wattage values.

Dmin Excel formula Example -3
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

What is Account Master & How to Create Modify and Delete

What is Account Master & How to Create Modify and Delete Administration > Masters &…