Maths and statistical functions in Canva Sheets
Maths and statistical functions help perform calculations such as addition, averages, rounding, and statistical analysis.
FUNCTION | WHAT IT DOES | EXAMPLE |
SUM | Adds up a range of numbers. | =SUM(A1:A10) |
AVERAGE | Calculates the average (mean) of a range of numbers. | =AVERAGE(A1:A10) |
MIN | Returns the smallest value in a range. | =MIN(A1:A10) |
MEDIAN | Returns the middle value in a range. | =MEDIAN(A1:A10) |
MAX | Returns the largest value in a range. | =MAX(A1:A10) |
COUNT | Counts the number of cells in a range that contain numbers. | =COUNT(A1:A10) |
COUNTA | Counts the number of cells that are not empty in a range. | =COUNTA(A1:A10) |
COUNTBLANK | Counts the number of empty cells in a range. | =COUNTBLANK(A1:A10) |
COUNTUNIQUE | Counts the number of unique values in a range. | =COUNTUNIQUE(A1:A10) |
MODE | Returns the most frequently occurring number in a dataset. | =MODE(A1:A10) |
CORREL | Calculates the correlation coefficient between two ranges. | =CORREL(A1:A10, B1:B10) |
PRODUCT | Multiplies the values in a given range. | =PRODUCT(A1:A5) |
SUMPRODUCT | Multiplies corresponding values in two or more arrays and sums the products. | =SUMPRODUCT(A1:A5, B1:B5) |
ROUND | Rounds a number to a specified number of decimal places. | =ROUND(A1, 2) |
ROUNDUP | Rounds a number up to the nearest integer or specified decimal place. | =ROUNDUP(A1, 2) |
ROUNDDOWN | Rounds a number down to the nearest integer or specified decimal place. | =ROUNDDOWN(A1, 2) |
ABS | Returns the absolute (positive) value of a number. | =ABS(A1) |
STDEV | Calculates the standard deviation of a dataset, measuring how spread out the values are. | =STDEV(A1:A10) |
VAR | Calculates the variance of a dataset. | =VAR(A1:A10) |
SQRT | Returns the square root of a number. | =SQRT(A1) |
EXP | Returns e (Euler’s number) raised to a given power. | =EXP(A1) |
LN | Returns the natural logarithm (base-e) of a number. | =LN(A1) |
LOG | Returns the logarithm of a number with a specified base. | =LOG(A1, 10) |
LOG10 | Returns the base-10 logarithm of a number. | =LOG10(A1) |
POWER | Raises a number to the power of another number. | =POWER(A1, 3) |
PI | Returns the value of π (Pi). | =PI() |
LARGE | Returns k-th largest value in data set | =LARGE(array, k) |
SMALL | Returns k-th smallest value in data set | =SMALL(array, k) |
ACOSH | Returns the inverse hyperbolic cosine | =ACOSH(number) |
ACOT | Returns the arccotangent of a number | =ACOT(number) |
ACOTH | Returns the inverse hyperbolic cotangent | =ACOTH(number) |
ASIN | Returns the arcsine of a number | =ASIN(number) |
ASINH | Returns the inverse hyperbolic sine | =ASINH(number) |
ATAN | Returns the arctangent of a number | =ATAN(number) |
ATAN2 | Returns the arctangent from x and y coordinates | =ATAN2(x_num, y_num) |
ATANH | Returns the inverse hyperbolic tangent | =ATANH(number) |
CEILING | Rounds up to nearest multiple | =CEILING(number, significance) |
CEILING.MATH | Rounds up with mode option | =CEILING.MATH(number, [significance], [mode]) |
CEILING.PRECISE | Rounds up to nearest multiple (absolute) | =CEILING.PRECISE(number, [significance]) |
COMBIN | Returns number of combinations | =COMBIN(number, number_chosen) |
COMBINA | Returns combinations with repetitions | =COMBINA(number, number_chosen) |
COS | Returns the cosine of an angle | =COS(number) |
COSH | Returns the hyperbolic cosine | =COSH(number) |
COT | Returns the cotangent of an angle | =COT(number) |
COTH | Returns the hyperbolic cotangent | =COTH(number) |
CSC | Returns the cosecant of an angle | =CSC(number) |
CSCH | Returns the hyperbolic cosecant | =CSCH(number) |
DEGREES | Converts radians to degrees | =DEGREES(angle) |
EVEN | Rounds up to nearest even integer | =EVEN(number) |
FACT | Returns factorial of a number | =FACT(number) |
FACTDOUBLE | Returns double factorial | =FACTDOUBLE(number) |
FLOOR | Rounds down to nearest multiple | =FLOOR(number, significance) |
FLOOR.MATH | Rounds down with mode option | =FLOOR.MATH(number, [significance], [mode]) |
FLOOR.PRECISE | Rounds down to nearest multiple (absolute) | =FLOOR.PRECISE(number, [significance]) |
GCD | Returns greatest common divisor | =GCD(number1, [number2], ...) |
INT | Rounds down to nearest integer | =INT(number) |
ISO.CEILING | Rounds up using ISO standard | =ISO.CEILING(number, [significance]) |
LCM | Returns least common multiple | =LCM(number1, [number2], ...) |
MOD | Returns remainder after division | =MOD(number, divisor) |
MROUND | Rounds to specified multiple | =MROUND(number, multiple) |
ODD | Rounds up to nearest odd integer | =ODD(number) |
PERMUT | Returns number of permutations | =PERMUT(number, number_chosen) |
PERMUTATIONA | Returns permutations with repetitions | =PERMUTATIONA(number, number_chosen) |
QUOTIENT | Returns integer portion of division | =QUOTIENT(numerator, denominator) |
RADIANS | Converts degrees to radians | =RADIANS(angle) |
SEC | Returns the secant of an angle | =SEC(number) |
SECH | Returns the hyperbolic secant | =SECH(number) |
SIGN | Returns sign of a number (-1, 0, or 1) | =SIGN(number) |
SIN | Returns the sine of an angle | =SIN(number) |
SINH | Returns the hyperbolic sine | =SINH(number) |
SQRTPI | Returns square root of (number × π) | =SQRTPI(number) |
SUMSQ | Returns sum of squares | =SUMSQ(number1, [number2], ...) |
SUMX2MY2 | Returns sum of difference of squares | =SUMX2MY2(array_x, array_y) |
SUMX2PY2 | Returns sum of sum of squares | =SUMX2PY2(array_x, array_y) |
SUMXMY2 | Returns sum of squares of differences | =SUMXMY2(array_x, array_y) |
TAN | Returns the tangent of an angle | =TAN(number) |
TANH | Returns the hyperbolic tangent | =TANH(number) |
TRUNC | Truncates to specified decimal places | =TRUNC(number, [num_digits]) |
Was this helpful?
Helpful
Unhelpful