VLOOKUP ABS

Mathematics

  • ABS — absolute value
  • ACOS — the arc cosine of x
  • ACOSH — the hyperbolic arc cosine of x
  • ACOT — inverse cotangent of x
  • ACOTH — the inverse hyperbolic cotangent of x
  • ARABIC — the Roman numeral roman as number
  • ASIN — the arc sine of x
  • ASINH — the inverse hyperbolic sine of x
  • ATAN — the arc tangent of x
  • ATAN2 — the arc tangent of the ratio y/x
  • ATANH — the inverse hyperbolic tangent of x
  • AVERAGEIF — average of the cells in actual range for which the corresponding cells in the range meet the given criteria
  • BETA — Euler beta function
  • BETALN — natural logarithm of the absolute value of the Euler beta function
  • CEIL — smallest integer larger than or equal to x
  • CEILING — nearest multiple of significance whose absolute value is at least ABS(x)
  • CHOLESKY — the Cholesky decomposition of the symmetric positive-definite matrix
  • COMBIN — binomial coefficient
  • COMBINA — the number of k-combinations of an n-element set with repetition
  • COS — the cosine of x
  • COSH — the hyperbolic cosine of x
  • COT — the cotangent of x
  • COTH — the hyperbolic cotangent of x
  • COUNTIF — count of the cells meeting the given criteria
  • CSC — the cosecant of x
  • CSCH — the hyperbolic cosecant of x
  • DEGREES — equivalent degrees to x radians
  • EIGEN — eigenvalues and eigenvectors of the symmetric matrix
  • EVEN — x rounded away from 0 to the next even integer
  • EXP — e raised to the power of x
  • EXPM1 — EXP(x)-1
  • FACT — the factorial of x, i.e. x!
  • FACTDOUBLE — double factorial
  • FIB — Fibonacci numbers
  • FLOOR — nearest multiple of significance whose absolute value is at most ABS(x)
  • G_PRODUCT — product of all the values and cells referenced
  • GAMMA — the Gamma function
  • GAMMALN — natural logarithm of the Gamma function
  • GCD — the greatest common divisor
  • GD — Gudermannian function
  • HYPOT — the square root of the sum of the squares of the arguments
  • INT — largest integer not larger than x
  • LCM — the least common multiple
  • LN — the natural logarithm of x
  • LN1P — LN(1+x)
  • LOG — logarithm of x with base base
  • LOG10 — the base-10 logarithm of x
  • LOG2 — the base-2 logarithm of x
  • MDETERM — the determinant of the matrix matrix
  • MINVERSE — the inverse matrix of matrix
  • MMULT — the matrix product of mat1 and mat2
  • MOD — the remainder of x under division by n
  • MROUND — x rounded to a multiple of m
  • MULTINOMIAL — multinomial coefficient (x1+⋯+xn) choose (x1,…,xn)
  • MUNIT — the n by n identity matrix
  • ODD — x rounded away from 0 to the next odd integer
  • ODF.SUMPRODUCT — multiplies components and adds the results
  • PI — the constant 𝜋
  • POWER — the value of x raised to the power y
  • PRODUCT — product of the given values
  • QUOTIENT — integer portion of a division
  • RADIANS — the number of radians equivalent to x degrees
  • ROMAN — n as a roman numeral text
  • ROUND — rounded x
  • ROUNDDOWN — x rounded towards 0
  • ROUNDUP — x rounded away from 0
  • SEC — Secant
  • SECH — the hyperbolic secant of x
  • SERIESSUM — sum of a power series at x
  • SIGN — sign of x
  • SIN — the sine of x
  • SINH — the hyperbolic sine of x
  • SQRT — square root of x
  • SQRTPI — the square root of x times 𝜋
  • SUM — sum of the given values
  • SUMA — sum of all values and cells referenced
  • SUMIF — sum of the cells in actual_range for which the corresponding cells in the range meet the given criteria
  • SUMPRODUCT — multiplies components and adds the results
  • SUMSQ — sum of the squares of all values and cells referenced
  • SUMX2MY2 — sum of the difference of squares
  • SUMX2PY2 — sum of the sum of squares
  • SUMXMY2 — sum of the squares of differences
  • TAN — the tangent of x
  • TANH — the hyperbolic tangent of x
  • TRUNC — x truncated to d digits
VLOOKUP ABS