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.
ABS()
Purpose: Returns the absolute (positive) value of a number.
Formula to use:
=ABS(A1)
Example:
If A1 = -25
=ABS(A1) returns 25
INT()
Purpose: Rounds a number down to the nearest integer.
Formula to use:
=INT(A1)
Example:
If A1 = 5.9
=INT(A1) returns 5
MOD()
Purpose: Returns the remainder after division.
Formula to use:
=MOD(A1,B1)
Example:
If A1 = 10
and B1 = 3
=MOD(A1,B1) returns 1
POWER()
Purpose: Raises a number to a specified power.
Formula to use:
=POWER(A1,B1)
Example:
If A1 = 4
and B1 = 3
=POWER(A1,B1) returns 64
SQRT()
Purpose: Returns the square root of a non-negative number.
Formula to use:
=SQRT(A1)
Example:
If A1 = 16
=SQRT(A1) returns 4
SIGN()
Purpose: Returns -1, 0, or 1 depending on the sign of the number.
Formula to use:
=SIGN(A1)
Example:
If A1 = -5 → returns -1
If A1 = 0 → returns 0
If A1 = 10 → returns 1
Rounding functions
ROUND()
Purpose: Rounds a number to a specified number of digits.
Formula to use:
=ROUND(A1,B1)
Example:
If A1 = 5.678
and B1 = 2
=ROUND(A1,B1) returns 5.68
ROUNDUP()
Purpose: Rounds a number away from zero.
Formula to use:
=ROUNDUP(A1,B1)
Example:
If A1 = 5.123
and B1 = 2
=ROUNDUP(A1,B1) returns 5.13
ROUNDDOWN()
Purpose: Rounds a number toward zero.
Formula to use:
=ROUNDDOWN(A1,B1)
Example:
If A1 = 5.987
and B1 = 2
=ROUNDDOWN(A1,B1) returns 5.98
TRUNC()
Purpose: Removes decimal places without rounding.
Formula to use:
=TRUNC(A1,B1)
Example:
If A1 = 5.987
and B1 = 1
=TRUNC(A1,B1) returns 5.9
CEILING()
Purpose: Rounds a number up to the nearest multiple.
Formula to use:
=CEILING(A1,B1)
Example:
If A1 = 23
and B1 = 5
=CEILING(A1,B1) returns 25
FLOOR()
Purpose: Rounds a number down to the nearest multiple.
Formula to use:
=FLOOR(A1,B1)
Example:
If A1 = 23
and B1 = 5
=FLOOR(A1,B1) returns 20
MROUND()
Purpose: Rounds a number to the nearest multiple.
Formula to use:
=MROUND(A1,B1)
Example:
If A1 = 23
and B1 = 5
=MROUND(A1,B1) returns 25
Aggregation & totals
SUM()
Purpose: Adds a range of values.
Formula to use:
=SUM(A1:A5)
Example:
If A1:A5 = 10, 20, 30, 40, 50
=SUM(A1:A5) returns 150
SUMIF()
Purpose: Returns the sum of values that meet a condition.
Formula to use:
=SUMIF(A1:A5,">10")
Example:
Returns the total of values greater than 10.
SUBTOTAL()
Purpose: Performs aggregation using a function code.
Formula to use:
=SUBTOTAL(9,A1:A5)
Example:
Function 9 represents SUM.
Returns the subtotal of the range.
PRODUCT()
Purpose: Multiplies multiple values together.
Formula to use:
=PRODUCT(A1:A3)
Example:
If A1:A3 = 2, 3, 4
=PRODUCT(A1:A3) returns 24
SUMSQ()
Purpose: Returns the sum of squares of values.
Formula to use:
=SUMSQ(A1:A3)
Example:
If A1:A3 = 2, 3
=SUMSQ(A1:A3) returns 13
(2² + 3²)
Logarithms & exponents
LN()
Purpose: Returns the natural logarithm of a positive number.
Formula to use:
=LN(A1)
Example:
If A1 = 10
=LN(A1) returns the natural log value.
LOG()
Purpose: Returns the logarithm with a custom base.
Formula to use:
=LOG(A1,B1)
Example:
If A1 = 100
and B1 = 10
=LOG(A1,B1) returns 2
LOG10()
Purpose: Returns the base-10 logarithm.
Formula to use:
=LOG10(A1)
Example:
If A1 = 1000
=LOG10(A1) returns 3
PI()
Purpose: Returns the value of π.
Formula to use:
=PI()
Example:
=PI() returns 3.14159
Trigonometry (angles in radians)
SIN()
Purpose: Returns the sine of an angle (in radians).
Formula to use:
=SIN(A1)
Example:
If A1 = RADIANS(90)
=SIN(A1) returns 1
If input is in degrees:
=SIN(RADIANS(A1))
COS()
Purpose: Returns the cosine of an angle (in radians).
Formula to use:
=COS(A1)
TAN()
Purpose: Returns the tangent of an angle (in radians).
Formula to use:
=TAN(A1)
RADIANS()
Purpose: Converts degrees to radians.
Formula to use:
=RADIANS(A1)
DEGREES()
Purpose: Converts radians to degrees.
Formula to use:
=DEGREES(A1)
Combinations & number systems
COMBIN()
Purpose: Returns the number of combinations (without repetition).
Formula to use:
=COMBIN(A1,B1)
GCD()
Purpose: Returns the greatest common divisor.
Formula to use:
=GCD(A1,B1)
BASE()
Purpose: Converts a number to another base.
Formula to use:
=BASE(A1,2)
ARABIC()
Purpose: Converts Roman numerals to Arabic numbers.
Formula to use:
=ARABIC(A1)
Random & unique values
RAND()
Purpose: Returns a random number between 0 and 1.
Formula to use:
=RAND()
RANDBETWEEN()
Purpose: Returns a random integer between two values.
Formula to use:
=RANDBETWEEN(A1,B1)
COUNTUNIQUE()
Purpose: Returns the count of unique values in a range.
Formula to use:
=COUNTUNIQUE(A1:A10)
Using math and trigonometry formulas in Dashpivot helps automate complex calculations, standardise financial and engineering computations, and reduce manual errors across your workflows.