Returns the smallest number in a field of records in a database that match the specified conditions.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
DMIN(database, field, criteria)The DMIN function evaluates a database table and extracts the minimum value from a specific column based on criteria you define. It is part of the database function family, which is useful for performing complex queries on structured data ranges.
=DMIN(A1:C10, "Price", E1:E2)Sonuç: 150
Finds the minimum value in the 'Price' column for records that match the criteria defined in E1:E2.
Yes, you can add multiple rows to your criteria range to create 'OR' logic or multiple columns for 'AND' logic.