Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Math
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Math

Instruction: ABS(value)
Returns: Returns the absolute value of a number. Learn more

Instruction: ACOS(value)
Returns: Returns the inverse cosine of a value, in radians. Learn more

Instruction: ACOSH(value)
Returns: Returns the inverse hyperbolic cosine of a number. Learn more

Instruction: ACOT(value)
Returns: Returns the inverse cotangent of a value, in radians. Learn more.

Instruction: ACOTH(value)
Returns: Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more.

Instruction: ASIN(value)
Returns: Returns the inverse sine of a value, in radians. Learn more

Instruction: ASINH(value)
Returns: Returns the inverse hyperbolic sine of a number. Learn more

Instruction: ATAN(value)
Returns: Returns the inverse tangent of a value, in radians. Learn more

Instruction: ATAN2(x, y)
Returns: Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (`x`,`y`), in radians. Learn more

Instruction: ATANH(value)
Returns: Returns the inverse hyperbolic tangent of a number. Learn more

Instruction: BASE(value, base, [min_length])
Returns: Converts a number into a text representation in another base, for example, base 2 for binary. Learn more.

Instruction: CEILING(value, [factor])
Returns: Rounds a number up to the nearest integer multiple of specified significance. Learn more

Instruction: CEILING.MATH(number, [significance], [mode])
Returns: Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more.

Instruction: CEILING.PRECISE(number, [significance])
Returns: Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more.

Instruction: COMBIN(n, k)
Returns: Returns the number of ways to choose some number of objects from a pool of a given size of objects. Learn more

Instruction: COMBINA(n, k)
Returns: Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times. Learn more.

Instruction: COS(angle)
Returns: Returns the cosine of an angle provided in radians. Learn more

Instruction: COSH(value)
Returns: Returns the hyperbolic cosine of any real number. Learn more

Instruction: COT(angle)
Returns: Cotangent of an angle provided in radians. Learn more.

Instruction: COTH(value)
Returns: Returns the hyperbolic cotangent of any real number. Learn more.

Instruction: COUNTBLANK(range)
Returns: Returns the number of empty cells in a given range. Learn more

Instruction: COUNTIF(range, criterion)
Returns: Returns a conditional count across a range. Learn more

Instruction: COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns: Returns the count of a range depending on multiple criteria. Learn more

Instruction: COUNTUNIQUE(value1, [value2, ...])
Returns: Counts the number of unique values in a list of specified values and ranges. Learn more

Instruction: CSC(angle)
Returns: Returns the cosecant of an angle provided in radians. Learn more.

Instruction: CSCH(value)
Returns: The CSCH function returns the hyperbolic cosecant of any real number. Learn more.

Instruction: DECIMAL(value, base)
Returns: The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more.

Instruction: DEGREES(angle)
Returns: Converts an angle value in radians to degrees. Learn more

Instruction: ERFC(z)
Returns: Returns the complementary Gauss error function of a value. Learn more

Instruction: ERFC.PRECISE(z)
Returns: See ERFC

Instruction: EVEN(value)
Returns: Rounds a number up to the nearest even integer. Learn more

Instruction: EXP(exponent)
Returns: Returns Euler's number, e (~2.718) raised to a power. Learn more

Instruction: FACT(value)
Returns: Returns the factorial of a number. Learn more

Instruction: FACTDOUBLE(value)
Returns: Returns the "double factorial" of a number. Learn more

Instruction: FLOOR(value, [factor])
Returns: Rounds a number down to the nearest integer multiple of specified significance. Learn more

Instruction: FLOOR.MATH(number, [significance], [mode])
Returns: Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more.

Instruction: FLOOR.PRECISE(number, [significance])
Returns: The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more.

Instruction: GAMMALN(value)
Returns: Returns the the logarithm of a specified Gamma function, base e (Euler's number). Learn more

Instruction: GAMMALN.PRECISE(value)
Returns: See GAMMALN

Instruction: GCD(value1, value2)
Returns: Returns the greatest common divisor of one or more integers. Learn more

Instruction: IMLN(complex_value)
Returns: Returns the logarithm of a complex number, base e (Euler's number). Learn more

Instruction: IMPOWER(complex_base, exponent)
Returns: Returns a complex number raised to a power. Learn more

Instruction: IMSQRT(complex_number)
Returns: Computes the square root of a complex number. Learn more

Instruction: INT(value)
Returns: Rounds a number down to the nearest integer that is less than or equal to it. Learn more

Instruction: ISEVEN(value)
Returns: Checks whether the provided value is even. Learn more

Instruction: ISO.CEILING(number, [significance])
Returns: See CEILING.PRECISE

Instruction: ISODD(value)
Returns: Checks whether the provided value is odd. Learn more

Instruction: LCM(value1, value2)
Returns: Returns the least common multiple of one or more integers. Learn more

Instruction: LN(value)
Returns: Returns the the logarithm of a number, base e (Euler's number). Learn more

Instruction: LOG(value, base)
Returns: Returns the the logarithm of a number given a base. Learn more

Instruction: LOG10(value)
Returns: Returns the the logarithm of a number, base 10. Learn more

Instruction: MOD(dividend, divisor)
Returns: Returns the result of the modulo operator, the remainder after a division operation. Learn more

Instruction: MROUND(value, factor)
Returns: Rounds one number to the nearest integer multiple of another. Learn more

Instruction: MULTINOMIAL(value1, value2)
Returns: Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more

Instruction: MUNIT(dimension)
Returns: Returns a unit matrix of size dimension x dimension. Learn more.

Instruction: ODD(value)
Returns: Rounds a number up to the nearest odd integer. Learn more

Instruction: PI()
Returns: Returns the value of Pi to 14 decimal places. Learn more

Instruction: POWER(base, exponent)
Returns: Returns a number raised to a power. Learn more

Instruction: PRODUCT(factor1, [factor2, ...])
Returns: Returns the result of multiplying a series of numbers together. Learn more

Instruction: QUOTIENT(dividend, divisor)
Returns: Returns one number divided by another. Learn more

Instruction: RADIANS(angle)
Returns: Converts an angle value in degrees to radians. Learn more

Instruction: RAND()
Returns: Returns a random number between 0 inclusive and 1 exclusive. Learn more

Instruction: RANDARRAY(rows, columns)
Returns: Generates an array of random numbers between 0 and 1. Learn more.

Instruction: RANDBETWEEN(low, high)
Returns: Returns a uniformly random integer between two values, inclusive. Learn more

Instruction: ROUND(value, [places])
Returns: Rounds a number to a certain number of decimal places according to standard rules. Learn more

Instruction: ROUNDDOWN(value, [places])
Returns: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more

Instruction: ROUNDUP(value, [places])
Returns: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more

Instruction: SEC(angle)
Returns: The SEC function returns the secant of an angle, measured in radians. Learn more.

Instruction: SECH(value)
Returns: The SECH function returns the hyperbolic secant of an angle. Learn more

Instruction: SEQUENCE(rows, columns, start, step)
Returns: Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.

Instruction: SERIESSUM(x, n, m, a)
Returns: Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more

Instruction: SIGN(value)
Returns: Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more

Instruction: SIN(angle)
Returns: Returns the sine of an angle provided in radians. Learn more

Instruction: SINH(value)
Returns: Returns the hyperbolic sine of any real number. Learn more

Instruction: SQRT(value)
Returns: Returns the positive square root of a positive number. Learn more

Instruction: SQRTPI(value)
Returns: Returns the positive square root of the product of Pi and the given positive number. Learn more

Instruction: SUBTOTAL(function_code, range1, [range2, ...])
Returns: Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more

Instruction: SUM(value1, [value2, ...])
Returns: Returns the sum of a series of numbers and/or cells. Learn more

Instruction: SUMIF(range, criterion, [sum_range])
Returns: Returns a conditional sum across a range. Learn more

Instruction: SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns: Returns the sum of a range depending on multiple criteria. Learn more

Instruction: SUMSQ(value1, [value2, ...])
Returns: Returns the sum of the squares of a series of numbers and/or cells. Learn more

Instruction: TAN(angle)
Returns: Returns the tangent of an angle provided in radians. Learn more

Instruction: TANH(value)
Returns: Returns the hyperbolic tangent of any real number. Learn more

Instruction: TRUNC(value, [places])
Returns: Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more