Functions in English | Functions in French | Description of Function |
---|
DAVERAGE | BDMOYENNE | Returns the average of selected database entries. |
DCOUNT | BDNB | Counts the cells that contain numbers in a database. |
DCOUNTA | BDNBVAL | Counts nonblank cells in a database. |
DGET | BDLIRE | Extracts from a database a single record that matches the specified criteria. |
DMAX | BDMAX | Returns the maximum value from selected database entries. |
DMIN | BDMIN | Returns the minimum value from selected database entries. |
DPRODUCT | BDPRODUIT | Multiplies the values in a particular field of records that match the criteria in a database. |
DSTDEV | BDECARTYPE | Estimates the standard deviation based on a sample of selected database entries. |
DSTDEVP | BDECARTYPEP | Calculates the standard deviation based on the entire population of selected database entries. |
DSUM | BDSOMME | Adds the numbers in the field column of records in the database that match the criteria. |
DVAR | BDVAR | Estimates variance based on a sample from selected database entries. |
DVARP | BDVARP | Calculates variance based on the entire population of selected database entries. |