Math

AVG

The AVG function calculates the average (arithmetic mean) of the provided numeric values.

Syntax: AVG(Number1, Number2, ...)

Number1, Number2, ...: Numeric values to average.

Mandatory: At least one number. Optional: Additional numbers.

Example: AVG(10, 20, 30) Returns: 20

CEIL

The CEIL function returns the smallest integer value greater than or equal to the given number.

Syntax: CEIL(Number)

Number: The numeric value to round up.

Example: CEIL(3.2) The function will return 4.

FLOOR

The FLOOR function returns the largest integer value less than or equal to the given number.

Syntax: FLOOR(Number)

Number: The numeric value to round down.

Example: FLOOR(3.8) The function will return 3.

FORMAT

The FORMAT function formats a number according to a specified decimal or string format.

Syntax: FORMAT(Number, "DF", FormatString)

Number: The numeric value to format. "DF": The format type (use "DF" for decimal format). FormatString: The format pattern (e.g., "##.00" for two decimal places).

Example: FORMAT(3.14159, "DF", "##.00") The function will return "3.14".

ROUND

The ROUND function rounds a number to the nearest integer.

Syntax: ROUND(Number)

Number: The numeric value to round.

Example: ROUND(3.6) The function will return 4.

SUM

The SUM function returns the sum of the provided numbers.

Syntax: SUM(Number1, Number2, ...)

Number1, Number2, ...: Numeric values to sum.

Mandatory: At least one number. Optional: Additional numbers.

Example: SUM(1, 2, 3) The function will return 6.