Round function

Use Round function to round a number to a specific number of digits. You can apply the Round function to the whole part or to the decimal part of a number.

Return type:  number

Syntax:

=ROUND(number, num_digits)

Arguments: 

number	-	The number you want to round. This is a required argument.
num_digits	-	The number of digits the number to be rounded to.  This is a required argument.

Remarks:

• If the num_digits is a positive number then the decimal part of the number is rounded.

• If the num_digits is a negative number then the whole part of the number is rounded resulting in an integer (See Examples section for information on this).

• If the num_digits is 0 (zero) then the number is rounded to the nearest integer.

Example:

DAVERAGE Function

Description:

In a database or list, the DAVERAGE function averages the values in a field column from the set of records that matches the condition(s) you specify.

Returns:   

Number

Syntax:

=DAVERAGE(database, field, criteria)

database The range of cells that makes up the list or database.
The first row of the list or database contains the labels for each column.
The following rows is the data. Each row is called a record.

fieldThe average is done for the column label (field) that you specify.
criteriaConditions that you specify are placed in this argument.
It is a must to specify at least one column label and at least one cell below the column label.

database
The range of cells that makes up the list or database.
The first row of the list or database contains the labels for each column.
The following rows is the data. Each row is called a record.
field
The average is done for the column label (field) that you specify.
criteria
Conditions that you specify are placed in this argument.
It is a must to specify at least one column label and at least one cell below the column label.