Excel Formulas

Showing page 13 of 21
ROUND
Math

Rounds a number to a specified number of digits

ROUNDUP
Math

Rounds a number up, away from 0

ROUNDDOWN
Math

Rounds a number down, toward 0

MROUND
Math

Returns a number rounded to the desired multiple

FLOOR
Math

Rounds a number down, toward zero, to the nearest multiple of significance

CEILING
Math

Rounds a number up, away from zero, to the nearest multiple of significance

INT
Math

Rounds a number down to the nearest integer

TRUNC
Math

Truncates a number to an integer by removing the fractional part of the number

ODD
Math

Rounds a number up to the nearest odd integer

EVEN
Math

Rounds a number up to the nearest even integer

FACT
Math

Returns the factorial of a number

FACTDOUBLE
Math

Returns the double factorial of a number

POWER
Math

Returns the result of a number raised to a power

EXP
Math

Returns e raised to the power of a given number

LN
Math

Returns the natural logarithm of a number

LOG
Math

Returns the logarithm of a number to a specified base

LOG10
Math

Returns the base-10 logarithm of a number

SQRT
Math

Returns a positive square root

SIGN
Math

Returns the sign of a number

ABS
Math

Returns the absolute value of a number

Page 13 of 21