ROUND() =ROUND(A2,2) : Round to decimals

ROUNDUP() =ROUNDUP(A2,0) : Always round up

ROUNDDOWN() =ROUNDDOWN(A2,0) : Always round down

MROUND() =MROUND(A2,5) : Round to nearest multiple

INT() =INT(A2) : Integer part

MOD() =MOD(A2,3) : Remainder

CEILING() =CEILING(A2,10) : Round up to multiple

FLOOR() =FLOOR(A2,10) : Round down to multiple

ABS() =ABS(A2) : Absolute value

POWER() =POWER(A2,3) : Raise to power

SQRT() =SQRT(A2) : Square root

RAND() =RAND() : Random 0-1

RANDBETWEEN() =RANDBETWEEN(1,100) : Random integer range

PI() =PI() : Pi constant

EXP() =EXP(1) : e^x function

LN() =LN(A2) : Natural logarithm

LOG() =LOG(A2,10) : Log base n

LOG10() =LOG10(A2) : Log base 10

PRODUCT() =PRODUCT(B2:B10) : Multiply set of numbers
Previous Next