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 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 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 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 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 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 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 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 ATAN function in Excel? ATAN function is one of the Math and Trig functions in Microsoft Excel that returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. Syntax of ATAN function ATAN(number) The …
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 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 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 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 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 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 COMBIN function in Excel? COMBIN function is one of the Math and Trig functions in Microsoft Excel that returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items. Syntax of COMBIN function COMBIN(number, number_chosen) The COMBIN function …
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 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 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 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 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 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 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 …
What is DECIMAL function in Excel? DECIMAL function is one of the Math and Trig functions in Microsoft Excel that converts a text representation of a number in a given base into a decimal number. Syntax of DECIMAL function DECIMAL(text, radix) The DECIMAL function syntax has the following arguments. Text: Radix: Radix must be an integer. …
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 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 …
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 …
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 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 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 …
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 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 …
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 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 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 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 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 MDETERM function in Excel? MDETERM function is one of the Math and Trig functions in Microsoft Excel that returns the matrix determinant of an array. Syntax of MDETERM function MDETERM(array) The MDETERM function syntax has the following arguments: Array: A numeric array with an equal number of rows and columns. MDETERM formula explanation Array …
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 SUM function in Excel? SUM function is one of Math and Trig functions in Microsoft Office Excel that adds all numbers in a range of cells and returns the result. Syntax of SUM function The syntax for the SUM function in Microsoft Excel is: SUM( number1, [number2, … number_n] ) OR SUM ( cell1:cell2, [cell3:cell4], …
To generate the ratio of two numbers to each other (e.g. 4:3, 16:9, etc.), you can do using division, the GCD function, and concatenation. In the formula of the formula below num1 represents the first number (the antecedent) and num2 represents the second number (the consequent). Formula =num1/GCD(num1,num2)&”:”&num2/GCD(num1,num2) Explanation In the example, the active cell contains this …