Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, “The test counts twice as much as the quiz and the final exam counts three times as much as the quiz”. 2. Below you can find the …
This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function. Int The INT (Integer) function rounds a number down to the nearest integer. Conclusion: the INT function only chops off decimals from positive numbers. Trunc Truncate a number to a given precision. The TRUNC (Truncate) function always chops off decimals. The TRUNC function can keep …
Find Nearest Multiple in Excel This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple of 10. 2. For example, round a number to the nearest multiple of 5. Ceiling The same as MROUND but rounds up. Floor The same as …
This example illustrates the EVEN and the ODD function in Excel. It also shows you how to determine if a number is even or odd. Even 1. Rounds a positive number up to the nearest even integer. 2. Rounds a negative number down to the nearest even integer. Odd 1. Rounds a positive number up to the nearest odd integer. …
The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples. Numbers 1. The SUMIF function below (two arguments) sums values in the range A1:A5 that are less than or equal to 10. 2. The following SUMIF function gives the exact same result. It uses the & operator to …
This example teaches you how to simulate the roll of two dice in Excel. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc. 1. At the moment, each cell contains …
The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it positive. 1. For example, the ABS function in cell B1 below returns the absolute value of a negative number. The ABS function has no effect on 0 (zero) or positive …
What is POWER function in Excel? POWER function is one of the Math and Trig functions in Microsoft Excel that returns the result of a number raised to a power. Let’s say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a …
What is SINH function in Excel? SINH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic sine of a number. Syntax of SINH function SINH(number) The SINH function syntax has the following arguments: Number: Any real number. SINH formula explanation The formula for the hyperbolic sine is: Example of SINH …
What is ACOS function in Excel? ACOS function is one of the Math and Trig functions in Microsoft Excel that returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. Syntax of ACOS function ACOS(number) …
What is COMBINA function in Excel? COMBINA function is one of the Math and Trig functions in Microsoft Excel that returns the number of combinations (with repetitions) for a given number of items. Syntax of COMBINA function COMBINA(number, number_chosen) The COMBINA function syntax has the following arguments. Number: Must be greater than or equal to 0, …
What is DEGREES function in Excel? DEGREES function is one of the Math and Trig functions in Microsoft Excel that converts radians into degrees. Syntax of DEGREES function DEGREES(angle) The DEGREES function syntax has the following arguments: Angle: The angle in radians that you want to convert. Example of DEGREES function Steps to follow: 1. Open a …
What is PRODUCT function in Excel? PRODUCT function is one of the Math and Trig functions in Microsoft Excel that multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform …
What is SQRT function in Excel? SQRT function is one of the Math and Trig functions in Microsoft Excel that returns a positive square root. Syntax of SQRT function SQRT(number) The SQRT function syntax has the following arguments: Number: The number for which you want the square root. SQRT formula explanation If number is negative, SQRT …
What is ACOSH function in Excel? ACOSH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number. Syntax of ACOSH function …
What is COS function in Excel? COS function is one of the Math and Trig functions in Microsoft Excel that returns the cosine of the given angle. Syntax of COS function COS(number) The COS function syntax has the following arguments: Number: The angle in radians for which you want the cosine. COS formula explanation If the …
What is INT function in Excel? INT function is one of the Math and Trig functions in Microsoft Excel that rounds a number down to the nearest integer. Syntax of INT function INT(number) The INT function syntax has the following arguments: Number: The real number you want to round down to an integer. Example of INT function …
What is QUOTIENT function in Excel? QUOTIENT function is one of the Math and Trig functions in Microsoft Excel that returns the integer portion of a division. Use this function when you want to discard the remainder of a division. Tip: If you want to divide numeric values, you should use the “/” operator as there …
What is SQRTPI function in Excel? SQRTPI function is one of the Math and Trig functions in Microsoft Excel that returns the square root of (number * pi). Syntax of SQRTPI function SQRTPI(number) The SQRTPI function syntax has the following arguments: Number: The number by which pi is multiplied. SQRTPI formula explanation If number < 0, …
What is ACOT function in Excel? ACOT function is one of the Math and Trig functions in Microsoft Excel that returns the principal value of the arccotangent, or inverse cotangent, of a number. Syntax of ACOT function ACOT(number) The ACOT function syntax has the following arguments. Number: Number is the cotangent of the angle you want. This …
What is COSH function in Excel? COSH function is one of the Maths and Trig functions in Microsoft Excel that returns the hyperbolic cosine of a number. Syntax of COSH function COSH(number) The COSH function syntax has the following arguments: Number: Any real number for which you want to find the hyperbolic cosine. COSH formula explanation …
What is GCD function in Excel? GCD function is one of the Math and Trig functions in Microsoft Excel that returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. Syntax of GCD function GCD(number1, [number2], …) The GCD …
What is RADIANS function in Excel? RADIANS function is one of the Math and Trig functions in Microsoft Excel that converts degrees to radians. Syntax of RADIANS function RADIANS(angle) The RADIANS function syntax has the following arguments: Angle: An angle in degrees that you want to convert. Example of RADIANS function Steps to follow: 1. Open a …
What is ACOTH function in Excel? ACOTH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic cotangent of a number. Syntax of ACOTH function ACOTH(number) The ACOTH function syntax has the following arguments. Number: The absolute value of Number must be greater than 1. ACOTH formula explanation The …
What is COT function in Excel? COT function is one of the Math and Trig functions in Microsoft Excel that return the cotangent of an angle specified in radians. Syntax of COT function COT(number) The COT function syntax has the following arguments. Number: The angle in radians for which you want the cotangent. COT formula explantion …
What is LCM function in Excel? LCM function is one of the Math and Trig functions in Microsoft Excel that returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with …
What is RAND function in Excel? RAND function is one of the Math and Trig functions in Microsoft Excel that returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated. Syntax of RAND function RAND() The …
What is SUMXMY2 function in Excel? SUMXMY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of squares of differences of corresponding values in two arrays. Syntax of SUMXMY2 function SUMXMY2(array_x, array_y) The SUMXMY2 function syntax has the following arguments: Array_x: The first array or range of values. Array_y: …
What is AGGREGATE function in Excel? AGGREGATE function is one of the Math and Trig functions in Microsoft Excel that returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. Syntax of AGGREGATE function Reference …
What is COTH function in Excel? COTH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cotangent of a hyperbolic angle. Syntax of COTH function COTH(number) The COTH function syntax has the following arguments. Number COTH formula explanation The hyperbolic cotangent is an analog of the ordinary (circular) cotangent. …
What is LN function in Excel? LN function is one of the Math and Trig functions in Microsoft Excel that returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). Syntax of LN function LN(number) The LN function syntax has the following arguments: Number: The positive real number for which …
What is RANDBETWEEN function in Excel? RANDBETWEEN function is one of the Math and Trig functions in Microsoft Excel that returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated. Syntax of RANDBETWEEN function RANDBETWEEN(bottom, top) The RANDBETWEEN function syntax has the following …
What is TAN function in Excel? TAN function is one of the Math and Trig functions in Microsoft Excel that returns the tangent of the given angle. Syntax of TAN function TAN(number) The TAN function syntax has the following arguments: Number: The angle in radians for which you want the tangent. TAN formula explanation If your …
What is ARABIC function in Excel? ARABIC function is one of the Math and Trig functions in Microsoft Excel that converts a Roman numeral to an Arabic numeral. Syntax of ARABIC function ARABIC( text ) The ARABIC function syntax has the following arguments. Text: A string enclosed in quotation marks, an empty string (“”), or a …
What is CSC function in Excel? CSC function is one of the Math and Trig functions in Microsoft Excel that returns the cosecant of an angle specified in radians. Syntax of CSC function CSC(number) The CSC function syntax has the following arguments. Number CSC formula explanation The absolute value of Number must be less than 2^27. …
What is LOG function in Excel? LOG function is one of the Math and Trig functions in Microsoft Excel that returns the logarithm of a number to the base you specify. Syntax of LOG function LOG(number, [base]) The LOG function syntax has the following arguments: Number: The positive real number for which you want the logarithm. …
What is ROMAN function in Excel? ROMAN function is one of the Math and Trig functions in Microsoft Excel that converts an arabic numeral to roman, as text. Syntax of ROMAN function ROMAN(number, [form]) The ROMAN function syntax has the following arguments: Number: The Arabic numeral you want converted. Form(Optional): A number specifying the type of …
What is TANH function in Excel? TANH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic tangent of a number. Syntax of TANH function TANH(number) The TANH function syntax has the following arguments: Number: Any real number. TANH formula explanation The formula for the hyperbolic tangent is: Example of TANH …
What is ASIN function in Excel? ASIN function is one of the Math and Trig functions in Microsoft Excel that returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. Syntax of ASIN function ASIN(number) The …
What is CSCH function in Excel? CSCH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cosecant of an angle specified in radians. Syntax of CSCH function CSCH(number) The CSCH function syntax has the following arguments. Number CSCH formula explanation The absolute value of Number must be less than …