The “Databases” functions in Excel allow you to apply calculations based on specific conditions. If you want to develop formulas in a database in Excel for BDMAX and BDMIN functions, we recommend that you read this article with which you will learn What is the function and syntax of BDMAX and BDMIN formula in Excel?
Excel functions are predefined procedures for perform precise calculations using a variety of arguments set by users. Some functions require syntax. However, for cases such as enabling or disabling the Excel autocomplete feature, there is no need to apply a syntax.
A function in Excel needs to insert a formula in a cell according to the categories available in the "Formulas" tab. With Excel you can apply functions such as sum, average and count or use trigonometric functions in Excel, in fact you can do many things with this application.
What are Excel functions used for?
Excel functions are used to perform from basic operations via arithmetic steps to complex tasks via conditions and / or nesting functions, such as logical functions (how to perform them).
Excel functions allow the user to perform easily mathematical and / or engineering calculations. It all depends on the arguments and variables you enter in the rows or columns of the sheet.
What is the function and syntax of BDMAX and BDMIN formula in Excel?
In the category "Databases" there are two functions widely used for the records management of tables in Excel . These functions are called “BDMAX” and “BDMIN”. Next, we explain what these functions consist of and the syntax for each of them.
Read How to stream or connect a tablet to a TV via USB, HDMI, WiFi, or wirelessly
What is the function and syntax of BDMAX formula in Excel?
The "BDMAX" function is a procedure that allows you to get the highest value found among a series of records in the database that corresponds to the parameters set by the user.
BDMAX function syntax includes: The range of cells that make up the database . Also, you need to add the field name (in quotes) where the function will be applied. Finally, the function requires specific conditions by using a range of cells that includes a table column.
Application of the BDMAX formula
An example of application of the BDMAX formula can be a table with five columns: ID, name, surname, age and num_children distributed from “A1” to “E11”.
If the database has 10 records and you want get the older age of the person with 2 children , you can set the formula as follows: = BDMAX (A1: E11; “Age”; E12: E13). Where "E12: E13" contains the condition "num_children" = 2.
What is the function and syntax of BDMIN formula in Excel?
The "BDMIN" function is a procedure that allows you to obtain the smallest value among a set of records (column) in the database. Like the “BDMAX” function, using “BDMIN” requires a number of parameters which are included in a syntax.
La "BDMIN" function syntax includes : the range of cells that defines a database table starting from the first column, the specific field with the column header (in quotation marks) or the letter and number that identify the cell. The last argument is the range of cells displayed by the condition to get the smallest value. For this reason, it is important to know the function argument separators in Excel when applying formulas.
Read How to prevent WhatsApp from sharing my information and data with Facebook
Application of the 'BDMIN' formula
There is a table with eight columns: serial, desc_equipo, platform, cpu, cap_ram, cap_hd, gpu and price in a database of 20 records. For get the lowest price for a Mac OS platform computer , we must apply the following syntax: = BDMIN (A1: H21; “Price”; H22: H23). Where "H22: H23" includes the condition that it is "Mac OS".