Level 15 Level 17
Level 16

Math and trigonometry functions - Part 3


21 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
ROUND
Rounds a number to a specified number of digits
ROUNDDOWN
Rounds a number down, toward zero
ROUNDUP
Rounds a number up, away from zero
SERIESSUM
Returns the sum of a power series based on the formula
SIGN
Returns the sign of a number
SIN
Returns the sine of the given angle
SINH
Returns the hyperbolic sine of a number
SQRT
Returns a positive square root
SQRTPI
Returns the square root of (number * pi)
SUBTOTAL
Returns a subtotal in a list or database
SUM
Adds its arguments
SUMIF
Adds the cells specified by a given criteria
SUMIFS
Adds the cells in a range that meet multiple criteria
SUMPRODUCT
Returns the sum of the products of corresponding array components
SUMSQ
Returns the sum of the squares of the arguments
SUMX2MY2
Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2
Returns the sum of squares of differences of corresponding values in two arrays
TAN
Returns the tangent of a number
TANH
Returns the hyperbolic tangent of a number
TRUNC
Truncates a number to an integer