Category Archives: Functions

The MOD Function

Kornilios Ampatzis/ April 19, 2019/ Functions

Returns the remainder after number is divided by divisor. The result has the same sign as divisor.

The RANDBETWEEN Function

Kornilios Ampatzis/ April 19, 2019/ Functions

Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated

The RAND Function

Kornilios Ampatzis/ April 19, 2019/ Functions

It returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.

The EXP Function

Kornilios Ampatzis/ April 19, 2019/ Functions

Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

The LN Function

Kornilios Ampatzis/ April 19, 2019/ Functions

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

The ABS Function

Kornilios Ampatzis/ April 19, 2019/ Functions

Returns the absolute value of a number. The absolute value of a number is the number without its sign.