Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
What is ASINH function in Excel? ASINH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number. Syntax of ASINH function ASINH(number) The ASINH function syntax has the following arguments: Number: …
What is ROUNDDOWN function in Excel? ROUNDDOWN function is one of the Math and Trig functions in Microsoft Excel that rounds a number down, toward zero. Syntax of ROUNDDOWN function ROUNDDOWN(number, num_digits) The ROUNDDOWN function syntax has the following arguments: Number: Any real number that you want rounded down. Num_digits: The number of digits to which you …
What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the squares of the arguments. Syntax of SUMSQ function SUMSQ(number1, [number2], …) The SUMSQ function syntax has the following arguments: Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 …
What is SO.CEILING function in Excel? SO.CEILING functionn is one of the Math and Trig functions in Microsoft Excel that returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or …
What is ODD function in Excel? ODD function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up to the nearest odd integer. Syntax of ODD function ODD(number) The ODD function syntax has the following arguments: Number: The value to round. ODD formula explanation If number is nonnumeric, ODD returns …
What is ROUNDUP function in Excel? ROUNDUP function is one of the Math and Trig functions in Microsoft Excel that rounds a number up, away from 0 (zero). Syntax of ROUNDUP function ROUNDUP(number, num_digits) The ROUNDUP function syntax has the following arguments: Number: Any real number that you want rounded up. Num_digits: The number of digits …
What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that multiplies corresponding components in the given arrays, and returns the sum of those products. Syntax of SUMSQ function SUMPRODUCT(array1, [array2], [array3], …) The SUMPRODUCT function syntax has the following arguments: Array1 Required. The first array argument …
What is ATAN2 function in Excel? ATAN2 function is one of the Math and Trig functions in Microsoft Excel that returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). …
What is FLOOR.PRECISE function in Excel? FLOOR.PRECISE function is one of the Math and Trig functions in Microsoft Excel that returns a number that is rounded down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down. However, if the number or …
The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …
What is MOD function in Excel? MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax of MOD function MOD(number, divisor) The MOD function syntax has the following arguments: Number: The number for which …
What is SEC function in Excel? SEC function is one of the Math and Trig functions in Microsoft Excel that returns the secant of an angle. Syntax of SEC function SEC(number) The SEC function syntax has the following arguments. Number: Number is the angle in radians for which you want the secant. SEC formula explanation The …
What is SUMIFS function in Excel? SUMIFS function is one of the Math and Trig functions in Microsoft Excel that adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose …
What is ATANH function in Excel? ATANH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number. Syntax of …
What is FLOOR.MATH function in Excel? FLOOR.MATH function is one of the Math and Trig functions in Microsoft Excel that round a number down to the nearest integer or to the nearest multiple of significance. Syntax of FLOOR.MATH function FLOOR.MATH(number, significance, mode) The FLOOR.MATH function syntax has the following arguments. Number: The number to be rounded …
This chapter illustrates three Mathematical functions ROUND, ROUNDUP and ROUNDDOWN. Navigation: Formula Tab → Function Library Group → Math & Trig Category Before your start: if you round a number, you lose precision. If you don’t want this, show fewer decimal places without changing the number itself. Round Syntax: ROUND(number, num_digits) 1. Round a number to two decimal places. …
Examples of MINVERSE function Example 1 Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all …
What is SECH function in Excel? SECH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic secant of an angle. Syntax of SECH function SECH(number) The SECH function syntax has the following arguments. Number: Number is the angle in radians for which you want the hyperbolic secant. SECH formula …
What is SUMIF function in Excel? SUMIF function is one of the Math and Trig functions in Microsoft Excel that is used to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger …
What is BASE function in Excel? BASE function is one of the Math and Trig functions in Microsoft Excel that r converts a number into a text representation with the given radix (base). Syntax of BASE function BASE(Number, Radix [Min_length]) The BASE function syntax has the following arguments. Number: The number that you want to convert. …
What is FLOOR function in Excel? FLOOR function is one of the Math and Trig functions in Microsoft Excel that rounds number down, toward zero, to the nearest multiple of significance. Syntax of FLOOR function FLOOR(number, significance) The FLOOR function syntax has the following arguments: Number: The numeric value you want to round. Significance: The multiple …
What is MUNIT function in Excel? MUNIT function is one of the Math and Trig functions in Microsoft Excel that returns the unit matrix for the specified dimension. Syntax of MUNIT function MUNIT(dimension) The MUNIT function syntax has the following arguments. Dimension: Dimension is an integer specifying the dimension of the unit matrix that you want …
What is SERIESSUM function in Excel? SERIESSUM function is one of the Math and Trig functions in Microsoft Excel that returns the sum of a power series based on the formula: Many functions can be approximated by a power series expansion. Syntax of SERIESSUM function SERIESSUM(x, n, m, coefficients) The SERIESSUM function syntax has the following …
What is SUBTOTAL function in Excel? SUBTOTAL function is one of the Math and Trig functions in Microsoft Excel that returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is …
What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula …
What is FACTDOUBLE function in Excel? FACTDOUBLE function is one of the Math and Trig functions in Microsoft Excel that returns the double factorial of a number. Syntax of FACTDOUBLE function FACTDOUBLE(number) The FACTDOUBLE function syntax has the following arguments: Number: The value for which to return the double factorial. If number is not an integer, …
What is MULTINOMIAL function in Excel? MULTINOMIAL function is one of the Math and Trig functions in Microsoft Excel that returns the ratio of the factorial of a sum of values to the product of factorials. Syntax of MULTINOMIAL function MULTINOMIAL(number1, [number2], …) The MULTINOMIAL function syntax has the following arguments: Number1, number2, … Number1 is required, …
What is SEQUENCE function in Excel? SEQUENCE function is one of the Math and Trig functions in Microsoft Excel that allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. Syntax of SEQUENCE function =SEQUENCE(rows, [columns], [start], [step]) SEQUENCE(number of row, number of columns,starting number, step size) …
What is TRUNC function in Excel? TRUNC function is one of the Math and Trig functions in Microsoft Excel that truncates a number to an integer by removing the fractional part of the number. Syntax of TRUNC function TRUNC(number, [num_digits]) The TRUNC function syntax has the following arguments: Number: The number you want to truncate. Num_digits(Optional): …
What is CEILING.MATH function in Excel? CEILING.MATH function is one of the Math and Trig functions in Microsoft Excel that rounds a number up to the nearest integer or to the nearest multiple of significance. Syntax of CEILING.MATH function CEILING.MATH(number, [significance], [mode]) The CEILING.MATH function syntax has the following arguments. Number: Number must be less than …
What is FACT function in Excel? FACT function is one of the Math and Trig functions in Microsoft Excel that returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number. Syntax of FACT function FACT(number) The FACT function syntax has the following arguments: Number: The nonnegative number for which you …
What is MROUND function in Excel? MROUND function is one of the Math and Trig functions in Microsoft Excel that returns a number rounded to the desired multiple. Syntax of MROUND function MROUND(number, multiple) The MROUND function syntax has the following arguments: Number: The value to round. Multiple: The multiple to which you want to round …
What is SIGN function in Excel? SIGN function is one of the Math and Trig functions in Microsoft Excel that determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. Syntax of SIGN function SIGN(number) The SIGN function syntax …
What is MMULT function in Excel? MMULT function is one of the Math and Trig functions in Microsoft Excel that returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. Syntax of MMULT function MMULT(array1, array2) The MMULT …
What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or …
What is EXP function in Excel? EXP function is one of the Math and Trig functions in Microsoft Excel that returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax of EXP function EXP(number) The EXP function syntax has the following arguments: Number: The exponent applied …
Example of PI function Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all the data, …
What is SIN function in Excel? SIN function is one of the Math and Trig functions in Microsoft Excel that returns the sine of the given angle. Syntax of SIN function SIN(number) The SIN function syntax has the following arguments: Number: The angle in radians for which you want the sine. SIN formula explanation If your …
What is ABS function in Excel? ABS function is one of the Math and Trig functions in Microsoft Excel that returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax of ABS function ABS(number) The ABS function syntax has the following arguments: Number: The real number …
What is EVEN function in Excel? EVEN function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate …