Math & Trig Functions
Mathematical and trigonometric functions
ABS Function
The Excel ABS function returns the absolute value of a number, removing its sign while preserving its magnitude. This is essential for mathematical calculations requiring positive values regardless of the input sign.
Learn MoreACOS Function
The Excel ACOS function returns the arccosine (inverse cosine) of a number, providing the angle in radians whose cosine equals the input value. It handles trigonometric calculations where you need the angle from a known cosine value within the valid range.
Learn MoreACOSH Function
The Excel ACOSH function calculates the inverse hyperbolic cosine of a number. This mathematical function returns the value whose hyperbolic cosine equals the input number, provided the input is 1 or greater. It's essential for advanced mathematical computations and engineering applications.
Learn MoreACOT Function
The Excel ACOT function calculates the principal value of the arccotangent (inverse cotangent) of a given number, returning the angle in radians whose cotangent equals that number. It's essential for advanced trigonometric calculations in Excel.
Learn MoreACOTH Function
The Excel ACOTH function calculates the inverse hyperbolic cotangent (hyperbolic arccotangent) of a number. This trigonometric function is essential for advanced mathematical calculations involving hyperbolic geometry and engineering applications.
Learn MoreAGGREGATE Function
The Excel AGGREGATE function performs calculations like AVERAGE, SUM, MAX, MIN and more on data ranges while intelligently ignoring hidden rows, error values, and nested SUBTOTAL/AGGREGATE functions based on specified options.
Learn MoreARABIC Function
The Excel ARABIC function converts Roman numerals to their Arabic (standard decimal) numeral equivalents. It provides a straightforward way to translate ancient Roman notation into modern numeric values used in calculations and data processing.
Learn MoreASIN Function
The Excel ASIN function returns the arcsine (inverse sine) of a number, expressed in radians. It calculates the angle whose sine equals the given number, with results ranging from -π/2 to π/2. Perfect for trigonometric calculations and engineering applications.
Learn MoreASINH Function
The Excel ASINH function calculates the inverse hyperbolic sine of a given number. This mathematical function returns the value whose hyperbolic sine equals the input number, making it essential for advanced engineering, physics, and statistical calculations involving hyperbolic functions.
Learn MoreATAN Function
The ATAN function in Excel calculates the arctangent (inverse tangent) of a specified number, returning the angle in radians whose tangent equals that number. This trigonometric function is essential for mathematical computations, geometric calculations, and engineering applications requiring angle determination from tangent values.
Learn MoreATAN2 Function
The Excel ATAN2 function calculates the arctangent of a point's coordinates, returning the angle in radians from the positive x-axis to the line connecting the origin with the specified (x, y) point. Unlike regular ATAN, ATAN2 properly handles all quadrants and distinguishes between positive and negative angles.
Learn MoreATANH Function
The Excel ATANH function calculates the inverse hyperbolic tangent of a number. This mathematical function is essential for advanced calculations involving hyperbolic functions, returning the value whose hyperbolic tangent equals the input number within the valid range.
Learn MoreBASE Function
The BASE function converts a decimal number into its representation in a specified base (radix), returning the result as text. It supports bases from 2 to 36 and can pad the output with leading zeros to meet a minimum length requirement.
Learn MoreCEILING Function
The Excel CEILING function rounds a number up to the nearest multiple of a specified significance value. It always rounds away from zero, making it ideal for pricing strategies, inventory calculations, and financial rounding where you need to consistently round up.
Learn MoreCEILING.MATH Function
The CEILING.MATH function rounds a number up to the nearest integer or to the nearest multiple of a specified significance. It provides flexible control over rounding direction for negative numbers, making it ideal for financial calculations, pricing strategies, and data normalization tasks.
Learn MoreCEILING.PRECISE Function
The CEILING.PRECISE function rounds a number up to the nearest integer or specified multiple, always using mathematical ceiling logic regardless of sign values. It ensures consistent upward rounding behavior for precise numerical adjustments.
Learn MoreCOMBIN Function
The Excel COMBIN function calculates the number of combinations possible for selecting a specified number of items from a larger set, without regard to order. It's essential for combinatorial mathematics, probability analysis, and statistical modeling in Excel.
Learn MoreCOMBINA Function
The COMBINA function calculates the number of combinations with repetition from a given set of items. Unlike standard combinations, COMBINA allows selecting the same item multiple times, making it ideal for scenarios like forming teams where members can be repeated or distributing identical objects into distinct groups.
Learn MoreCOS Function
The Excel COS function calculates the cosine of a specified angle provided in radians. This trigonometric function is essential for mathematical calculations, geometric analysis, and scientific computations within spreadsheets.
Learn MoreCOSH Function
The Excel COSH function calculates the hyperbolic cosine of a given number, a fundamental mathematical operation used in engineering, physics, and advanced statistical analysis.
Learn MoreCOT Function
The Excel COT function calculates the cotangent of an angle provided in radians. Cotangent is the reciprocal of tangent (1/tan(x)) and is essential for advanced trigonometric calculations in engineering, physics, and mathematical modeling.
Learn MoreCOTH Function
The Excel COTH function calculates the hyperbolic cotangent of a given number, providing essential trigonometric functionality for advanced mathematical and engineering calculations in spreadsheets.
Learn MoreCSC Function
The Excel CSC function calculates the cosecant of an angle provided in radians. As the reciprocal of the sine function, CSC is essential for trigonometric calculations in engineering, physics, and advanced mathematical analysis within spreadsheets.
Learn MoreCSCH Function
The Excel CSCH function calculates the hyperbolic cosecant of an angle given in radians. This mathematical function is essential for advanced engineering and scientific calculations involving hyperbolic trigonometry.
Learn MoreDCOUNTA Function
The Excel DCOUNTA function counts nonblank cells in a specified field of a database that match given criteria. It is part of Excel's database functions and can count all matching records when the field argument is omitted.
Learn MoreDECIMAL Function
The DECIMAL function converts a text representation of a number from any base (2-36) into its decimal (base 10) equivalent. Perfect for handling hexadecimal, binary, or custom base conversions directly in Excel formulas.
Learn MoreDEGREES Function
The Excel DEGREES function converts angles measured in radians to degrees, making it essential for trigonometric calculations and mathematical conversions within spreadsheets.
Learn MoreERROR.TYPE Function
The ERROR.TYPE function identifies specific Excel error values by returning a unique number for each error type. This enables precise error handling and conditional logic based on the exact error encountered in formulas.
Learn MoreEVEN Function
The Excel EVEN function rounds a number up to the nearest even integer. It's particularly useful for calculations involving pairs or twos, such as packaging, inventory management, or any scenario where items must be grouped in even quantities.
Learn MoreEXP Function
The EXP function calculates e raised to the power of a given number, where e is the mathematical constant approximately equal to 2.71828 (base of the natural logarithm). This is essential for exponential growth calculations, compound interest, and scientific modeling.
Learn MoreFACT Function
The Excel FACT function calculates the factorial of a nonnegative integer, returning the product of all positive integers from 1 up to the specified number. Essential for permutation calculations and combinatorial analysis.
Learn MoreFACTDOUBLE Function
The FACTDOUBLE function calculates the double factorial of a number, multiplying it by every second positive integer down to either 2 (for even numbers) or 1 (for odd numbers). This specialized math function is essential for advanced statistical calculations and combinatorial analysis.
Learn MoreFILTERXML Function
FILTERXML extracts specific data from XML content using XPath queries. This powerful function enables Excel users to parse structured XML data directly within spreadsheets, making it ideal for processing web service responses, API data, and XML documents.
Learn MoreFLOOR.MATH Function
The FLOOR.MATH function in Excel rounds a number down to the nearest integer or to the nearest multiple of a specified value. It provides precise control over rounding direction, especially for negative numbers, making it ideal for financial calculations and data alignment tasks.
Learn MoreFLOOR.PRECISE Function
The FLOOR.PRECISE function rounds a number down to the nearest integer or specified multiple, always toward negative infinity regardless of the sign of the number or significance value. This ensures consistent mathematical flooring behavior across all numeric inputs.
Learn MoreGCD Function
The Excel GCD function calculates the greatest common divisor (GCD) of two or more integers. The GCD represents the largest positive integer that fully divides each of the given numbers without leaving a remainder, making it essential for simplifying fractions and mathematical analysis.
Learn MoreINT Function
The Excel INT function rounds a number down to the nearest integer, always truncating toward zero for positive numbers and away from zero for negative numbers. It's essential for extracting whole numbers from decimal values in financial calculations, data processing, and statistical analysis.
Learn MoreISERR Function
The ISERR function in Excel detects whether a value represents any error except the #N/A error. It returns TRUE for errors like #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!, but returns FALSE for #N/A errors and non-error values.
Learn MoreISEVEN Function
The Excel ISEVEN function determines if a given number is even by returning TRUE for even integers and FALSE for odd integers. It automatically truncates decimal portions and handles dates by converting them to their serial number equivalents.
Learn MoreISNA Function
The Excel ISNA function specifically detects the #N/A error value, returning TRUE when a formula or cell contains #N/A and FALSE for all other values including other error types. This makes it essential for handling 'value not available' conditions common in lookup operations.
Learn MoreISNONTEXT Function
The ISNONTEXT function determines if a value is anything other than text, returning TRUE for numbers, dates, logical values, errors, or blank cells. It's essential for data validation and conditional logic that requires distinguishing non-text content from text strings.
Learn MoreISO.CEILING Function
The ISO.CEILING function rounds a number up to the nearest integer or to the nearest multiple of a specified significance, always rounding away from zero regardless of the sign of the number or significance. This follows international mathematical standards for ceiling operations.
Learn MoreISODD Function
The ISODD function determines whether a given number is odd, returning TRUE for odd numbers and FALSE for even numbers. This logical test is essential for pattern-based calculations, conditional formatting, and data analysis tasks requiring parity checks.
Learn MoreISREF Function
The ISREF function determines whether a given value is a valid cell reference in Excel. It returns TRUE for valid references like A1 or B10, and FALSE for non-references such as numbers, text, or invalid addresses.
Learn MoreISTEXT Function
The ISTEXT function determines whether a given value is text, returning TRUE for text values and FALSE for numbers, dates, logical values, errors, or blank cells. This makes it essential for data validation and conditional processing in Excel spreadsheets.
Learn MoreLCM Function
The Excel LCM function calculates the least common multiple of two or more integers. This is the smallest positive integer that is evenly divisible by all the given numbers, making it essential for working with fractions that have different denominators.
Learn MoreLN Function
The Excel LN function calculates the natural logarithm of a positive number, using base e (approximately 2.71828). This is a fundamental mathematical operation essential for growth modeling, scientific calculations, and advanced financial analysis.
Learn MoreLOG Function
The Excel LOG function calculates the logarithm of a specified number using a customizable base. When no base is provided, it defaults to base 10, making it perfect for logarithmic calculations in finance, science, and data analysis.
Learn MoreLOG10 Function
The Excel LOG10 function calculates the base-10 logarithm of a positive number. It returns the exponent to which 10 must be raised to produce the specified number, making it essential for logarithmic calculations in scientific, financial, and engineering analysis.
Learn MoreMDETERM Function
The MDETERM function calculates the determinant of a square matrix, a key value in linear algebra used to determine if a matrix is invertible and for solving systems of linear equations.
Learn MoreMINVERSE Function
The MINVERSE function computes the inverse of a square matrix provided as an array. Essential for linear algebra operations, matrix inversion enables solving systems of linear equations and various advanced mathematical computations in Excel.
Learn MoreMMULT Function
The MMULT function performs matrix multiplication between two arrays, producing a result array with dimensions matching the row count of the first array and column count of the second array. This powerful tool is essential for linear algebra operations and advanced data analysis in Excel.
Learn MoreMOD Function
The Excel MOD function calculates the remainder after dividing one number by another. Unlike standard division, MOD preserves the sign of the divisor in the result, making it invaluable for cyclic calculations, date arithmetic, and modular operations.
Learn MoreMROUND Function
The Excel MROUND function rounds a number to the nearest specified multiple. Unlike standard ROUND which rounds to decimal places, MROUND rounds to any multiple you specify - perfect for currency, inventory, scheduling, and measurement applications.
Learn MoreMULTINOMIAL Function
The Excel MULTINOMIAL function calculates the multinomial coefficient, which is the ratio of the factorial of the sum of given numbers to the product of their individual factorials. This is essential for combinatorial calculations in probability and statistics.
Learn MoreMUNIT Function
The MUNIT function generates an identity matrix of specified dimensions, essential for matrix algebra operations in Excel. It creates a square matrix with ones on the main diagonal and zeros elsewhere, serving as the multiplicative identity in matrix multiplication.
Learn MoreN Function
The Excel N function converts a value to a number according to specific conversion rules. It returns the numeric value for numbers and dates, converts TRUE to 1 and FALSE to 0, preserves error values, and returns 0 for all other inputs like text.
Learn MoreNA Function
The NA function in Excel intentionally returns the #N/A error value, signaling that no data is available for that cell. This is essential for marking missing information in datasets, ensuring calculations properly handle data gaps without treating them as zeros or blanks.
Learn MoreODD Function
The Excel ODD function rounds a given number up to the nearest odd integer. It always rounds away from zero, making it perfect for ensuring values meet odd-number requirements in calculations like scheduling, inventory, or financial modeling.
Learn MorePERCENTOF Function
The PERCENTOF function calculates what percentage a subset of values represents of a total dataset. It's designed for dynamic array calculations and works seamlessly within GROUPBY and PIVOTBY functions for percentage breakdowns.
Learn MorePI Function
The PI function returns the mathematical constant π (pi) with high precision, accurate to 15 decimal places. This is essential for geometric calculations, trigonometry, and any formula requiring the circle constant.
Learn MorePOWER Function
The Excel POWER function calculates a number raised to a specified power, equivalent to the exponentiation operation. It's perfect for mathematical calculations requiring exponents, growth modeling, scientific computations, and engineering formulas where precise power calculations are essential.
Learn MorePRODUCT Function
The Excel PRODUCT function multiplies all supplied numbers or cell ranges together and returns the result. It's perfect for calculating totals from multiple values without typing lengthy multiplication formulas.
Learn MoreQUOTIENT Function
The Excel QUOTIENT function returns the integer portion of a division, effectively discarding the remainder. It's perfect for scenarios where you need whole numbers from division operations without fractional parts.
Learn MoreRADIANS Function
The RADIANS function converts angle measurements from degrees to radians, essential for trigonometric calculations in Excel that require radian inputs.
Learn MoreRAND Function
The RAND function generates a random decimal number between 0 (inclusive) and 1 (exclusive). Each time the worksheet recalculates, RAND produces a fresh random value, making it perfect for simulations, sampling, and randomized data generation.
Learn MoreRANDARRAY Function
The RANDARRAY function generates an array of random numbers dynamically, perfect for simulations, testing, and data analysis. It creates arrays of specified dimensions filled with random values between defined limits.
Learn MoreRANDBETWEEN Function
The RANDBETWEEN function generates a random integer within a specified range, from a minimum bottom value to a maximum top value. Every time the worksheet recalculates, it produces a fresh random integer, making it perfect for simulations, testing, and random data generation.
Learn MoreROMAN Function
The Excel ROMAN function converts Arabic numerals into Roman numerals as text output. It supports multiple formatting styles from traditional classic Roman notation to modern simplified versions, making it perfect for creating elegant numbering in reports, titles, and historical documents.
Learn MoreROUND Function
The ROUND function precisely rounds any number to a specified number of decimal places or significant digits. It follows standard rounding rules where .5 and above rounds up, below .5 rounds down, making it essential for financial calculations, data presentation, and statistical analysis.
Learn MoreROUNDDOWN Function
The Excel ROUNDDOWN function rounds a number down to a specified number of digits, always toward zero. Unlike the standard ROUND function, ROUNDDOWN never rounds up, making it perfect for conservative estimates, flooring calculations, and precise financial truncations.
Learn MoreROUNDUP Function
The Excel ROUNDUP function rounds a number up to a specified number of digits, always rounding away from zero regardless of the number's sign. Unlike standard ROUND which rounds to nearest, ROUNDUP consistently increases the magnitude of the value.
Learn MoreSEC Function
The Excel SEC function calculates the secant of a given angle in radians, providing essential trigonometric functionality for mathematical computations and engineering analysis.
Learn MoreSECH Function
The Excel SECH function calculates the hyperbolic secant of an angle provided in radians. This mathematical function returns 1 divided by the hyperbolic cosine (COSH) of the specified angle, useful for advanced engineering and scientific calculations.
Learn MoreSEQUENCE Function
The SEQUENCE function generates an array of sequential numbers, creating lists like 1, 2, 3, 4 automatically. It's perfect for quickly building number sequences, date ranges, or any patterned data without manual entry.
Learn MoreSERIESSUM Function
The Excel SERIESSUM function calculates the sum of a power series expansion using the formula: sum of coefficients[i] * x^(n + i*m). This powerful mathematical function enables approximation of complex functions through Taylor or Maclaurin series expansions directly within Excel spreadsheets.
Learn MoreSHEET Function
The SHEET function returns the sheet number (position) of a specified sheet name, reference, or table within the workbook. It provides a dynamic way to identify sheet positions for formulas that need to reference sheets by their numeric order rather than hardcoded names.
Learn MoreSHEETS Function
The Excel SHEETS function counts the total number of sheets within a specified reference or the entire workbook. It provides quick insight into workbook structure by including all sheet types regardless of visibility status.
Learn MoreSIGN Function
The Excel SIGN function determines the sign of a number, returning 1 for positive values, 0 for zero, and -1 for negative values. It's a simple yet powerful tool for mathematical analysis and conditional logic.
Learn MoreSIN Function
The Excel SIN function calculates the sine of a specified angle provided in radians. This trigonometric function is essential for mathematical computations, physics calculations, and waveform analysis in spreadsheets.
Learn MoreSINH Function
The Excel SINH function calculates the hyperbolic sine of a given number, a key mathematical operation used in engineering, physics, and statistical analysis for modeling exponential growth and decay processes.
Learn MoreSQRT Function
The Excel SQRT function calculates the positive square root of a given number. It's a fundamental mathematical function essential for geometric calculations, statistical analysis, and financial modeling where square root operations are required.
Learn MoreSQRTPI Function
The Excel SQRTPI function calculates the square root of (number × π), providing a direct way to compute this common mathematical operation without separate multiplication and square root functions.
Learn MoreSUBTOTAL Function
The Excel SUBTOTAL function performs aggregate calculations on filtered lists or databases, intelligently ignoring filtered-out rows and optionally excluding manually hidden rows. Perfect for dynamic summary tables that update automatically when filters are applied.
Learn MoreSUM Function - Add Numbers Effortlessly in Excel
The SUM function is Excel's essential tool for totaling numeric values from individual cells, ranges, or combinations. Perfect for quick calculations, financial summaries, and data aggregation.
Learn MoreSUMIF Function
The SUMIF function in Excel sums values in a specified range that meet single criteria you define. It's perfect for conditional totaling like summing only sales above a target or commissions for specific regions, making data analysis quick and targeted.
Learn MoreSUMIFS Function
The SUMIFS function sums values in a specified range that meet multiple criteria across different ranges. It's perfect for complex data analysis where you need to filter and sum based on several conditions simultaneously.
Learn MoreSUMPRODUCT Function
The SUMPRODUCT function multiplies corresponding elements in one or more arrays and then sums the resulting products. This powerful function handles multi-criteria calculations without needing array formulas or helper columns.
Learn MoreSUMSQ Function
The Excel SUMSQ function calculates the sum of squares of all provided numbers. This powerful mathematical function is essential for statistical calculations, variance computation, and vector magnitude determination.
Learn MoreSUMX2MY2 Function
The SUMX2MY2 function calculates the sum of the difference of squares between corresponding values in two arrays. It computes Σ(x² - y²) for each pair of values, providing a mathematical shortcut for analyzing differences between datasets.
Learn MoreSUMX2PY2 Function
The SUMX2PY2 function calculates the sum of the sum of squares of corresponding values from two arrays. This powerful statistical tool adds up (x² + y²) for each pair of values, making it essential for vector magnitude calculations and statistical analysis.
Learn MoreSUMXMY2 Function
The Excel SUMXMY2 function calculates the sum of the squares of differences between corresponding values in two arrays. This is a statistical function commonly used in regression analysis and data comparison tasks.
Learn MoreTAN Function
The Excel TAN function calculates the tangent of a specified angle provided in radians. This trigonometric function is essential for mathematical computations, engineering calculations, and geometric analysis within spreadsheets.
Learn MoreTANH Function
The Excel TANH function calculates the hyperbolic tangent of a given number, a key mathematical operation used in advanced calculations, engineering applications, and statistical modeling.
Learn MoreTRUNC Function
The Excel TRUNC function removes the fractional part of a number, returning the integer portion without rounding. Unlike rounding functions, TRUNC simply truncates toward zero regardless of the number's sign.
Learn MoreTYPE Function
The Excel TYPE function identifies the data type of a value, returning a numeric code that indicates whether the value is a number, text, logical value, error, array, or compound data. This is essential for dynamic formulas that behave differently based on input types.
Learn More