Numeric Functions

The following numeric functions perform calculations. Mathematical and Boolean operators are described in a separate section. Functions differ from operators in that functions pass arguments and return a result, whereas operators return a result by combining two numeric expressions.

Trigonometric Functions

The following are the trigonometric functions that are supported in Office Basic.

Exponential and Logarithmic Functions

Office Basic supports the following exponential and logarithmic functions.

Generating Random Numbers

The following statements and functions generate random numbers.

Square Root Calculation

Use this function to calculate square roots.

Integers and Fractional

Functions to round values to integers, and to take the fractional part of a value.

Absolute Values

This function returns absolute values.

Expression Signs

This function returns the algebraic sign of a numeric expression.

Converting Numbers

The following functions convert numbers from one format to another.