Returns the smallest number in a field of records in a database that match the specified conditions.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 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.