Math and Trigonometry Formulas in Dashpivot

Dashpivot offers the most common formulas that perform complex calculations, data analysis, problem solving and decision-making. These are the main uses of the formulas:

Data Analysis
Problem-solving and Optimization
Data Visualisation
Engineering and Physics
Project Management
Finance

Make use of the math and trigonometry formulas in Dashpivot to streamline your forms and make processes much easier to track.

Function ID	Description	Syntax	Sample	Results	Notes
ABS	Returns the absolute value of a number.	ABS(Number)	=ABS(A1) *A1 - Number field Given that, A1 = -20	Returns value, 20.00
ARABIC	Converts number from roman form.	ARABIC(String)	=ARABIC(“XIV”)	Returns value, 14.00	Formula doesn’t work for text fields. The string must be written in the formula.
BASE	Converts a positive integer to a specified base into a text from the numbering system.	BASE(Number, Radix, [Minimumlength])	=BASE(A1, 2) *A1 - Number field Given that, A1 = 10	Returns value, 1010	The number to be converted must be: 2^53>Number>=0 Radix: Must be an integer between 2 and 36; must be included in the formula as it doesn’t work when used in a cell
CEILING	Rounds a number up to the nearest multiple of Significance.	CEILING(Number, Significance)	=CEILING(A1, B1) *A1 & B1 - Number field Given that, A1 = 2.3 B1 = 0.5	Returns value, 2.5
CEILING.MATH	Rounds a number up to the nearest multiple of Significance.	CEILING.MATH(Number[, Significance[, Mode]])	=CEILING.MATH(A1, B1, C1) *A1, B1 & C1 - Number field Given that, A1 = 2.3 B1 = 1 C1 = 1	Returns value, 3	Significance: If omitted, the default is 1 Mode: If omitted, the default is 0
CEILING.PRECISE	Rounds a number up to the nearest multiple of Significance.	CEILING.PRECISE(Number[, Significance])	=CEILING.PRECISE(2.3, 0.5) *A1 & B1 - Number field Given that, A1 = 2.3 B1 = 0.5	Returns value, 2.5	Significance: If omitted, the default value is 1
COMBIN	Returns number of combinations (without repetitions).	COMBIN(Number1, Number2)	=COMBIN(5, 3)	Returns value, 10 (Because there are 10 ways to choose 3 items from a set of 5, given that it doesn’t matter the positions)	Number1: total number of items Number 2: the number of items to choose from the total Note: This formula does not work if the number is in a cell. Formula only works if the numbers are included in the formula already itself.
COMBINA	Returns number of combinations (with repetitions).	COMBINA(Number1, Number2)	=COMBINA(5, 3)	Returns value, 35 (Because there are 35 ways to choose 3 items from a set of 5, given that the positions matter)	Number1: total number of items Number 2: the number of items to choose from the total Note: This formula does not work if the number is in a cell. Formula only works if the numbers are included in the formula already itself.
COS	Returns the cosine of the given angle (in radians).	COS(Number)	=COS(A1) *A1 - Number field Given that, A1 = 0	Returns value, 1	Number: the angle in radians In using pi, use PI() such as [=COS(PI()/3)]
COT	Returns the cotangent of the given angle (in radians).	COT(Number)	=COT(A1) *A1 - Number field Given that, A1 = 1	Returns value, 0.6421	Number: the angle in radians In using pi, use PI() such as [=COS(PI()/3)]
COUNTUNIQUE	Counts the number of unique values in a list of specified values and ranges.	COUNTUNIQUE(Value1, [Value2, ...])	=COUNTUNIQUE(A1:A5) *A1:A5 - Number field Given that, A = [1, 2, 2, 3, 4]	Returns value, 4 (Because the unique values are 1, 2, 3, and 4)
CSC	Returns the cosecans of the given angle (in radians).	CSC(Number)	=CSC(A1) *A1 - Number field Given that, A1 = 1	Returns value, 1.19	Number: the angle in radians In using pi, use PI() such as [=COS(PI()/3)]
CSCH	Returns the hyperbolic cosecant of the given value.	CSCH(Number)	=CSCH(A1) *A1 - Number field Given that, A1 = 1	Returns value, 0.85	Number: the angle in radians In using pi, use PI() such as [=COS(PI()/3)]
DECIMAL	Converts text with characters from a number system to a positive integer in the base radix given.	DECIMAL("Text", Radix)	= DECIMAL(A1, B1) A1 - Text field B1 - Number field Given that, A1 = Z1 B1 = 36		Text: must be a valid string representation of a number Radix: integer from 2 to 36
DEGREES	Converts radians into degrees.	DEGREES(Number)	= DEGREES(A1) *A1 - Number field Given that, A1 = 1 (value in radians)	Returns value, 57.30	The cell must be in radians to convert into degrees.
EVEN	Rounds a positive number up to the next even integer and a negative number down to the next even integer.	EVEN(Number)	=EVEN(A1) *A1 - Number field Given that, A1 -= 3	Returns the value, 4	Notes: If the number is already even, the function returns the same number. If the number is odd, the function rounds it up to the next even integer. If the number is negative, it rounds away from zero to the next even integer (more negative).
FLOOR	Rounds a number down to the nearest multiple of Significance.	FLOOR(Number, Significance)	=FLOOR(A1, B1) *A1 & B1 - Number field Given that, A1 = 23.7 B1 = 5	Returns value, 20 (Because 23.7 is rounded down to the nearest multiple of 5)
GCD	Computes greatest common divisor of numbers.	GCD(Number1, Number2, ...)	=GCD(A1, B1) *A1 & B1 - Number field Given that, A1 = 48 B1 = 60	Returns value, 12
INT	Rounds a number down to the nearest integer.	INT(Number)	=INT(A1) *A1 - Number field Given that, A1 = 8.3	Returns value, 8
LCM	Computes least common multiplicity of numbers.	LCM(Number1, Number2, ...)	= LCM(A1, B1) *A1 & B1 - Number field Given that, A1 = 4 B1 = 5	Returns value, 20
LN	Returns the natural logarithm based on the constant e of a number.	LN(Number)	= LN(A1) *A1 - Number field Given that, A1 = 10	Returns value, 2.30	LN() only works with positive numbers. Using 0 or negative numbers will return #NUM! error`
LOG	Returns the logarithm of a number to the specified base.	LOG(Number, Base)	= LOG(A1) *A1 - Number field Given that, A1 = 100	Returns value, 2
LOG10	Returns the base-10 logarithm of a number.	LOG10(Number)	= LOG10(A1) *A1 - Number field Given that, A1 = 100	Returns value, 2
MOD	Returns the remainder when one integer is divided by another.	MOD(Dividend, Divisor)	=MOD(A1, B1) *A1 & B1 - Number field Given that, A1 = 17 B1 = 5	Returns value, 2 (Because 17 divided by 5 is 3 with a remainder of 2)
MROUND	Rounds number to the nearest multiplicity.	MROUND(Number, Base)	MROUND(E1,”00:15”) *E1 = Time Field		”00:15” - rounds to closest 15 minutes ”00:30” - rounds to the closest 30 minutes
ODD	Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.	ODD(Number)	=ODD(A1) *A1 - Number field Given that, A1 = 3.2	Returns value, 5 (Because 3.2 is rounded up to the nearest odd integer)
PI	Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.	PI()	= PI()	Returns value, 3.14
POWER	Returns a number raised to another number.	POWER(Base, Exponent)	=POWER(A1, 3) *A1 - Number field Given that, A1 = 2	Returns value, 8	Note that the exponent should be included in the formula for it to work.
PRODUCT	Returns product of numbers.	PRODUCT(Number1, Number2, ..., Number30)	= PRODUCT(A1, B1) *A1 & B1 - Number field Given that, A1 = 10 B1 = 2	Returns value, 10
QUOTIENT	Returns integer part of a division.	QUOTIENT(Dividend, Divisor)	=QUOTIENT(A1, B1) *A1 & B1 - Number field Given that, A1 = 7.5 B1 = 2	Returns value, 3.75	Note that if the denominator is 0, the function returns a #DIV/0! error
RADIANS	Converts degrees to radians.	RADIANS(Number)	=RADIANS(A1) *A1 - Number field Given that, A1 = 45 (value in degrees)	Returns value, 0.79
RAND	Returns a random number between 0 and 1.	RAND()	=RAND()	Returns value, Any integer between 0 and 1, inclusive.
RANDBETWEEN	Returns a random integer between two numbers.	RAND(Lowerbound, Upperbound)	=RANDBETWEEN(A1, B1) *A1 & B1 - Number field Given that, A1 = 0 B1 = 100	Returns value, Any integer between 0 and 100, inclusive.
ROUND	Rounds a number to a certain number of decimal places.	ROUND(Number, Count)	=ROUND(A1, 2) *A1 - Number field Given that, A1 = 1.234	Returns value, 1.23 (because 1.234 is closer to 1.23 than 1.24)	Count: 0: round to the nearest whole number. Positive: round to a specified number of decimal places. Negative: round to the left of the decimal point (i.e., to the nearest ten, hundred, etc.).
ROUNDDOWN	Rounds a number down, toward zero, to a certain precision.	ROUNDDOWN(Number, Count)	=ROUNDDOWN(A1, 2) *A1 - Number field Given that, A1 = 1.234	Returns value, 1.23	Count: 0: round to the nearest whole number. Positive: round to a specified number of decimal places. Negative: round to the left of the decimal point (i.e., to the nearest ten, hundred, etc.).
ROUNDUP	Rounds a number up, away from zero, to a certain precision.	ROUNDUP(Number, Count)	=ROUNDUP(A1, 2) *A1 - Number field Given that, A1 = 1.234	Returns value, 1.24	Count: 0: round to the nearest whole number. Positive: round to a specified number of decimal places. Negative: round to the left of the decimal point (i.e., to the nearest ten, hundred, etc.).
SEC	Returns the secant of the given angle (in radians).	SEC(Number)	=SEC(A1) *A1 - Number field Given that, A1 = 1	Returns value, 1.85	The SEC() formula requires the angle in radians. If the input cell (A1) is in degrees, you can use RADIANS() formula, for example: [=SEC(RADIANS(A1))] If without value in the number cell, the default value is 1.
SECH	Returns the hyperbolic secant of the given angle (in radians).	SEC(Number)	=SECH(A1) *A1 - Number field Given that, A1 = 0	Returns value, 1	The SECH() formula requires the angle in radians. If the input cell (A1) is in degrees, you can use RADIANS() formula, for example: [=SECH(RADIANS(A1))]
SERIESSUM	Evaluates series at a point.	SERIESSUM(x, n, m, Coefficients)	=SERIESSUM(2, 0, 2, A1:A3) Meaning, Series: (A1) + (A2)x2 + (A3)x4 at x = 2 x = 2 n = 0 m = 2 Given that, A1 = 4 A2 = 5 A3 = 6	Returns value, 120.00	1 + 2x2 + 3x at x = 2 x: the variable in order to evaluate the series; x = 2 in the example above n: the starting exponents of the first term; n = 0 in the example above m: the step size of the exponents; m = 1 Coefficients: the coefficients in the series A1 = 1 A2 = 2 A3 = 3 If all these values are directly placed in the formula, it would look like this: [=SERIESSUM(2, 0, 1, A1:A3)]
SIN	Returns the sine of the given angle (in radians).	SIN(Number)	=SIN(RADIANS(A1)) *A1 - Number field Given that, A1 = 30	Returns value, 0.5	The SIN() formula requires the angle in radians. If the input cell (A1) is in degrees, you can use RADIANS() formula, for example: [=SIN(RADIANS(A1))]
SINH	Returns the hyperbolic sine of the given value.	SINH(Number)	=SINH(RADIANS(A1)) *A1 - Number field Given that, A1 = 45 (value in degrees)	Returns value, 0.87	The SINH() formula requires the angle in radians. If the input cell (A1) is in degrees, you can use RADIANS() formula, for example: [=SINH(RADIANS(A1))]
SIGN	Returns sign of a number.	SIGN(Number)	=SIGN(A1) *A1 - Number field Given that, A1 = -40	Returns value, -1 (Beacuse -40 is negative)	Results: 1: If the number is positive. -1: If the number is negative. 0: If the number is zero.
SQRT	Returns the positive square root of a number.	SQRT(Number)	Ex. 1 =SQRT(A1) A1 - Number field Given that, A1 = 9 _________ Ex. 2 =SQRT(A1 + B1) A1 & B1 - Number field Given that, A1 = 4 B1 = 5	Ex. 1 Returns value, 3 _________ Ex. 2 Returns value, 3	This formula is only applicable for non-negative numbers.
SQRTPI	Returns sqrt of number times pi.	SQRTPI(Number)	=SQRTPI(A1) *A1 - Number field Given that, A1 = 10	Returns value, 5.60	Note that if you input a negative number, an error will return.
SUBTOTAL	Computes aggregation using function specified by number.	SUBTOTAL(Function, Number1, Number2, ... Number30)	=SUBTOTAL(9, A1:A3) *A1:A3 - Number field Given that, A = [10, 15, 20]	Returns value, 45 (The function 9 means SUM)	Function: 1: AVERAGE 2: COUNT 3: COUNTA 4: MAX 5: MIN 6: PRODUCT 7: STDEV 8: STDEVP 9: SUM 10: VAR
SUM	Sums up the values of the specified cells.	SUM(Number1, Number2, ..., Number30)	=SUM(A1:A3) *A1:A3 - Number field Given that, A = [5, 10, 15]	Returns value, 30	Text values and empty cells are ignored.
SUMIF	Sums up the values of cells that belong to the specified range and meet the specified condition.	SUMIF(Range, Criteria, Sumrange)	=SUMIFS(B1:B3, A1:A3, “Supplier A”) A1:A3 - List/text field B1:B3 - Number field Given that, A = [SupplierA, SupplierB, Supplier A] B = [100, 200, 300]	Returns value, 400 (Because it only calculates the total in the range B1:B3 with the given criteria)	Criteria: can be a text, number or list field; the criteria ranges must be the same size and shape as the sum range
SUMIFS	Sums up the values of cells that belong to the specified range and meet the specified sets of conditions.	SUMIFS(Sum_Range , Criterion_range1 , Criterion1 [ , Criterion_range2 , Criterion2 [,...]])
SUMSQ	Returns the sum of the squares of the arguments	SUMSQ(Number1, Number2, ..., Number30)	=SUMSQQ(A1:A3) *A1:A3 - Number field Given that, A = [1, 2, 3]	Returns value, 14	This formula can be used for individual numbers and adding the squares of multiple numbers.
TAN	Returns the tangent of the given angle (in radians).	TAN(Number)	Ex. 1 =TAN(A1) A1 - Number field Given that, A1 = 1 (value in radians) ___________ Ex. 2 =TAN(RADIANS(A1)) A1 - Number field Given that, A1 = 45 (value in degrees) ____________ Ex. 3 =TAN(PI()/A1) *A1 - Number field Given that, A1 = 6 (value of the denominator)	Ex. 1 Returns value, 1.56 __________ Ex. 2 Returns value, 1.00 __________ Ex. 3 Returns value, 0.58	The TAN() formula requires the angle in radians. If the input cell (A1) is in degrees, you can use RADIANS() formula, for example: [=TAN(RADIANS(A1))] If you want to use pi, use the formula as shown: [=TAN(PI()/6]
TANH	Returns the hyperbolic tangent of the given value.	TANH(Number)	=TANH(A1) *A1 - Number field Given that, A1 = -1	Returns value, -0.76	Note that the result of TANH() is always between -1 and 1.
TRUNC	Truncates a number by removing decimal places.	TRUNC(Number, Count)	=TRUNC(A1, 0) *A1 - Number field Given that, A1 = 123.456	Returns value, 123	Count: if omitted, the default is 0 (meaning the number is truncated to an integer); cannot be a reference cell (meaning the value should be included already in the formula) Note that the TRUNC() formula does not round the number. It only removes the decimal places.