abs-positive |
ABS |
=ABS(3) |
value |
|
abs-negative |
ABS |
=ABS(-3.4) |
value |
|
abs-zero |
ABS |
=ABS(0) |
value |
|
ceiling-round-up |
CEILING |
=CEILING(2.5, 1) |
value |
|
ceiling-negative-both |
CEILING |
=CEILING(-2.5, -2) |
value |
|
ceiling-negative-num-positive-sig |
CEILING |
=CEILING(-2.5, 2) |
value |
|
ceiling-fractional-significance |
CEILING |
=CEILING(0.234, 0.01) |
value |
|
ceiling-positive-num-negative-sig |
CEILING |
=CEILING(2, -2) |
value |
1 |
ceiling-math-basic |
CEILING.MATH |
=CEILING.MATH(5.2) |
value |
1 |
ceiling-math-with-significance |
CEILING.MATH |
=CEILING.MATH(5.2, 2) |
value |
1 |
floor-basic |
FLOOR |
=FLOOR(3.7, 2) |
value |
|
floor-negative |
FLOOR |
=FLOOR(-2.5, -2) |
value |
|
floor-fractional |
FLOOR |
=FLOOR(1.58, 0.1) |
value |
|
floor-precision |
FLOOR |
=FLOOR(0.234, 0.01) |
value |
|
floor-zero-significance |
FLOOR |
=FLOOR(2, 0) |
value |
1 |
floor-math-basic |
FLOOR.MATH |
=FLOOR.MATH(5.2) |
value |
1 |
floor-math-with-significance |
FLOOR.MATH |
=FLOOR.MATH(5.2, 2) |
value |
1 |
int-positive |
INT |
=INT(8.9) |
value |
|
int-negative-rounds-down |
INT |
=INT(-8.9) |
value |
1 |
mod-basic |
MOD |
=MOD(5, 2) |
value |
|
mod-no-remainder |
MOD |
=MOD(6, 3) |
value |
|
mod-negative-dividend |
MOD |
=MOD(-5, 2) |
value |
1 |
mod-zero-divisor |
MOD |
=MOD(5, 0) |
value |
|
power-basic |
POWER |
=POWER(10, 2) |
value |
|
power-fractional |
POWER |
=POWER(2.5, 2) |
value |
|
power-negative-exponent |
POWER |
=POWER(2, -3) |
value |
|
round-up |
ROUND |
=ROUND(0.6, 0) |
value |
|
round-down |
ROUND |
=ROUND(1.3, 0) |
value |
|
round-to-1-decimal |
ROUND |
=ROUND(1.25, 1) |
value |
|
round-negative-decimals |
ROUND |
=ROUND(1234, -2) |
value |
|
round-floating-point-edge |
ROUND |
=ROUND(1.05*(0.0284+0.0046)-0.0284, 4) |
value |
1 |
roundup-basic |
ROUNDUP |
=ROUNDUP(1.24, 1) |
value |
|
rounddown-basic |
ROUNDDOWN |
=ROUNDDOWN(1.26, 1) |
value |
|
sqrt-perfect-square |
SQRT |
=SQRT(4) |
value |
|
sqrt-irrational |
SQRT |
=SQRT(2) |
value |
3 |
sqrt-negative |
SQRT |
=SQRT(-4) |
value |
1 |
sum-scalars |
SUM |
=SUM(1, 2, 3) |
value |
|
sum-array-literal-row |
SUM |
=SUM({1, 2, 3}) |
value |
|
sum-array-literal-column |
SUM |
=SUM({1; 2; 3}) |
value |
|
sum-2d-array |
SUM |
=SUM({1, 2; 3, 4; 5, 6}) |
value |
|
sum-with-grid-range |
SUM |
=SUM(A1:A3) |
value |
|
sum-no-args |
SUM |
=SUM() |
value |
|
sumproduct-basic |
SUMPRODUCT |
=SUMPRODUCT(A1:A3, B1:B3) |
value |
2 |
exp-zero |
EXP |
=EXP(0) |
value |
|
exp-one |
EXP |
=EXP(1) |
value |
3 |
sign-positive |
SIGN |
=SIGN(10) |
value |
|
sign-zero |
SIGN |
=SIGN(0) |
value |
|
sign-negative |
SIGN |
=SIGN(-10) |
value |
|
mround-basic |
MROUND |
=MROUND(10, 3) |
value |
1 |
trunc-integer-unchanged |
TRUNC |
=TRUNC(10) |
value |
|
trunc-to-1-decimal |
TRUNC |
=TRUNC(10.22, 1) |
value |
|
sumsq-single |
SUMSQ |
=SUMSQ(2) |
value |
1 |
sumsq-two-values |
SUMSQ |
=SUMSQ(1, 2) |
value |
1 |
ln-e |
LN |
=LN(2.718281828459045) |
value |
1 |
log-base-10 |
LOG |
=LOG(10) |
value |
|
log-base-2 |
LOG |
=LOG(8, 2) |
value |
|
log10 |
LOG10 |
=LOG10(100000) |
value |
|
fact-5 |
FACT |
=FACT(5) |
value |
|
fact-0 |
FACT |
=FACT(0) |
value |
|
fact-negative |
FACT |
=FACT(-1) |
value |
1 |
quotient-basic |
QUOTIENT |
=QUOTIENT(5, 2) |
value |
1 |
even-1-5 |
EVEN |
=EVEN(1.5) |
value |
|
even-3 |
EVEN |
=EVEN(3) |
value |
|
even-negative |
EVEN |
=EVEN(-1) |
value |
|
pi |
PI |
=PI() |
value |
3 |