Math & Trigonometry Functions

ABS converts negative numbers to positive, leaving positive numbers unchanged.

Returns the angle (in radians) whose cosine is the supplied number.

Returns the angle (in radians) whose sine is the supplied number.

Returns the angle (in radians) whose tangent is the supplied number.

Returns the angle in radians to a point given by its x and y coordinates.

Rounds a number up to the nearest multiple of significance.

Rounds up to a multiple of significance, with a mode for negative numbers.

Returns the cosine of an angle given in radians.

Converts radians to degrees.

Returns e raised to a power.

Rounds a number down to the nearest multiple of significance.

Rounds down to a multiple of significance, with a mode for negative numbers.

Rounds a number down to the nearest integer.

Returns the natural (base-e) logarithm of a number.

Returns the logarithm of a number to a given base (default 10).

Returns the base-10 logarithm of a number.

Returns the remainder after division, with the sign of the divisor.

Rounds a number to the nearest multiple of a given value.

Returns the constant π (about 3.14159).

POWER calculates number^power, raising a base number to an exponent.

Multiplies together all supplied numbers.

Converts degrees to radians.

ROUND rounds numbers to a given number of decimal places, following standard rounding rules.

ROUNDDOWN always rounds numbers down, never up, to the specified decimal places.

ROUNDUP always rounds numbers up, never down, to the specified decimal places.

Returns 1, 0, or -1 indicating a number's sign.

Returns the sine of an angle given in radians.

SQRT calculates the square root of a number.

SUMIF adds values that match a condition. Give it a range to check, a condition to test, and a range of numbers to sum — it only adds the ones that pass the test.

Adds numbers that meet all of the specified conditions.

Sums the products of corresponding array elements; great for conditional calculations.

Returns the tangent of an angle given in radians.

Truncates a number to an integer or set number of digits (no rounding).