# What is a MATH formula in a spreadsheet?

Math formulas and functions encompass basic arithmetic operations (addition, subtraction, multiplication, division), trigonometric functions, logarithms, exponents, rounding, and other mathematical calculations.

## MATH formula usage examples.

The ATAN2 function returns the angle between the x-axis and a line segment from the origin (0,0) to a specified coordinate pair (x,y) in radians. It takes two arguments: x and y, representing the coordinates of the point. The function calculates the angle using the arctangent of y/x, taking into account the signs of both x and y to determine the correct quadrant of the angle.

The BASE function is used to convert a number into a text representation in another base. It takes three arguments: value, base, and optional min_length. The value argument is the number to be converted. The base argument specifies the base of the desired representation, such as 2 for binary, 16 for hexadecimal, or 8 for octal. The optional min_length argument specifies the minimum number of characters in the resulting text representation.

The CEILING.MATH function rounds a number up to the nearest integer multiple of a specified significance. It takes three arguments: 'number' (the number to be rounded), 'significance' (the desired multiple), and 'mode' (optional, determines the rounding direction for negative numbers). CEILING.MATH is useful for scenarios where values need to be rounded up to a specific increment, such as project deadlines, inventory management, or sales forecasting.

The CEILING.PRECISE function rounds a number up to the nearest integer multiple of a specified significance. If the number is positive or negative, it is rounded up. The 'number' argument represents the number to be rounded, and the 'significance' argument represents the desired interval or unit for rounding. CEILING.PRECISE ensures that the rounded number is always greater than or equal to the original number.

The CEILING function is used to round a number up to the nearest integer multiple of a specified significance. It takes two arguments: the value to be rounded and the factor (optional) which determines the significance. If the factor is not provided, the function rounds the value up to the nearest integer.

The COSH function is used to calculate the hyperbolic cosine of a given value. The hyperbolic cosine is a mathematical function that is used in various applications, such as calculating loan payments, analyzing stock prices, and modeling population growth. The COSH function takes a single parameter, which represents the value for which the hyperbolic cosine is calculated.

The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). It takes two arguments: 'value' which is the text representation of the number, and 'base' which is the base of the number system used in the 'value' argument. The function returns the decimal equivalent of the number.

The FLOOR.MATH function rounds a number down to the nearest integer multiple of a specified significance. It takes three arguments: 'number' is the value to be rounded down, 'significance' is the multiple to which the number should be rounded down, and 'mode' (optional) determines how negative numbers are rounded. If 'mode' is omitted, it defaults to 0, which rounds negative numbers towards zero. If 'mode' is set to 1, negative numbers are rounded away from zero.

The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. It takes two arguments: 'number' represents the value to be rounded down, and 'significance' (optional) represents the interval at which the rounding should occur. If 'significance' is not provided, the function rounds down to the nearest integer.

The FLOOR function rounds a number down to the nearest integer multiple of the specified significance. It takes two arguments: 'value' is the number to be rounded down, and 'factor' is the significance to which the number should be rounded down. If 'factor' is omitted, the function rounds down to the nearest integer.

The GAMMALN.PRECISE function is used to calculate the natural logarithm of the gamma function. The gamma function is an extension of the factorial function to real and complex numbers. The natural logarithm of the gamma function is often used in statistical and mathematical calculations, such as calculating probabilities, densities, and likelihoods.

The POWER function returns a number raised to a power. It takes two arguments: the base number and the exponent. The base number is the number you want to raise to a power, and the exponent is the power to which you want to raise the base number. The result is the base number raised to the specified power.

The PRODUCT function returns the result of multiplying a series of numbers together. It takes multiple arguments, each representing a factor to be multiplied. The function can accept up to 255 arguments. If any of the arguments are non-numeric, the function returns the #VALUE! error. If any of the arguments are empty or equal to 0, the function returns 0.

The ROUND function is used to round a number to a certain number of decimal places according to standard rules. It takes two arguments: 'value' is the number to be rounded, and 'places' is the number of decimal places to round to. If 'places' is omitted, the function rounds to the nearest whole number.

The ROUNDDOWN function rounds a number down to a certain number of decimal places, always rounding down to the next valid increment. It takes two arguments: 'value' is the number to be rounded down, and 'places' (optional) specifies the number of decimal places to round down to. If 'places' is not provided, the function rounds down to the nearest whole number.

The ROUNDUP function is used to round a number to a certain number of decimal places, always rounding up to the next valid increment. It takes two arguments: value, which is the number to be rounded, and places (optional), which specifies the number of decimal places to round to. If places is not provided, the function rounds to the nearest whole number.

The SEQUENCE function returns an array of sequential numbers. It is useful for generating lists, calendars, and matrices. The 'rows' parameter specifies the number of rows in the array, the 'columns' parameter specifies the number of columns, the 'start' parameter specifies the starting value, and the 'step' parameter specifies the increment between numbers.

The SERIESSUM function calculates the sum of a power series with varying coefficients and exponents. It takes four arguments: x, n, m, and a. The 'x' argument represents the input value for the power series. The 'n' argument represents the initial exponent for the first term in the series. The 'm' argument represents the difference in exponents between consecutive terms. The 'a' argument represents the range of coefficients for each term in the series. The function returns the sum of all terms in the power series.

The SUMIF function calculates a sum based on a specified condition. It takes three arguments: range, criterion, and [sum_range]. The range is the range of cells to be evaluated for the condition. The criterion is the condition that determines which cells to include in the sum. The [sum_range] is an optional argument that specifies the range of cells to be summed. If omitted, the range argument is used as the sum_range.

The SUMIFS function calculates the sum of a range based on multiple criteria. It takes a sum_range as the first argument, which is the range of cells to sum. The subsequent arguments are pairs of criteria_range and criterion, where criteria_range is the range of cells to evaluate and criterion is the condition to be met. The function adds up the values in the sum_range that meet all the specified criteria.

The TANH function returns the hyperbolic tangent of a given value. The hyperbolic tangent is a mathematical function that describes the relationship between the angle of a right triangle and the ratio of the lengths of its sides. In Excel, the TANH function takes a single argument, which is the value for which we want to calculate the hyperbolic tangent. The result is a numeric value that represents the hyperbolic tangent of the input value.

The TRUNC function is used to truncate a number to a certain number of significant digits by omitting less significant digits. It takes two arguments: 'value' which is the number to be truncated, and 'places' which is an optional argument specifying the number of decimal places to keep. If 'places' is not provided, the function truncates the number to the nearest integer.