Excel Functions You Need to Know: Mathematical Functions
Part 1 of a comprehensive series on Excel functions.
Excel is a powerful tool for working with data, and one of its strengths is the wide range of built-in functions that it offers. Whether you need to perform simple arithmetic calculations or complex statistical analyses, Excel has a function to help you get the job done. In the first post of this series on Excel’s functions, we’ll take a look at some of the more prevalent mathematical functions available in Excel and provide examples of how they can be used.
SUM: Adds up a range of numbers.
Example: =SUM(A1:A10)
AVERAGE: Calculates the average of a range of numbers.
Example: =AVERAGE(A1:A10)
MIN: Returns the smallest value in a range of numbers.
Example: =MIN(A1:A10)
MAX: Returns the largest value in a range of numbers.
Example: =MAX(A1:A10)
ROUND: Rounds a number to a specified number of decimal places.
Example: =ROUND(A1, 2)
TRUNC: Truncates a number to a specified number of decimal places.
Example: =TRUNC(A1, 2)
INT: Rounds a number down to the nearest integer.
Example: =INT(A1)
CEILING: Rounds a number up to the nearest specified multiple.
Example: =CEILING(A1, 5)
FLOOR: Rounds a number down to the nearest specified multiple.
Example: =FLOOR(A1, 10)
PRODUCT: Multiplies the values in a range of cells.
Example: =PRODUCT(A1:A10)
QUOTIENT: Returns the integer portion of a division operation.
Example: =QUOTIENT(A1, B1)
MOD: Returns the remainder after division of two numbers.
Example: =MOD(A1, B1)
POWER: Raises a number to a specified power.
Example: =POWER(A1, B1)
SQRT: Calculates the square root of a number.
Example: =SQRT(A1)
ABS: Returns the absolute value of a number.
Example: =ABS(A1)
LOG: Calculates the logarithm (base 10) of a number.
Example: =LOG(A1)
EXP: Returns e raised to the power of a number.
Example: =EXP(A1)
RAND: Returns a random number between 0 and 1.
Example: =RAND()
RANDBETWEEN: Returns a random integer between two specified values.
Example: =RANDBETWEEN(1, 10)
SUMIF: Adds up the values in a range that meet a specified criterion.
Example: =SUMIF(A1:A10, “>5”)
SUMIFS: Adds up the values in a range that meet multiple specified criteria.
Example: =SUMIFS(A1:A10, B1:B10, “>5”, C1:C10, “<10”)
COUNT: Counts the number of cells in a range that contain numbers.
Example: =COUNT(A1:A10)
COUNTA: Counts the number of cells in a range that contain any type of data.
Example: =COUNTA(A1:A10)
COUNTIF: Counts the number of cells in a range that meet a specified criterion.
Example: =COUNTIF(A1:A10, “>5”)
COUNTIFS: Counts the number of cells in a range that meet multiple specified criteria.
Example: =COUNTIFS(A1:A10, “>5”, B1:B10, “<10”)
SUMPRODUCT: Multiplies the corresponding values in two or more ranges and adds up the results.
Example: =SUMPRODUCT(A1:A10, B1:B10)
These are more prevalent mathematical functions available in Excel. By mastering these functions and others like them, you can quickly perform complex calculations and analyses on your data
Subscribe to follow along: https://medium.com/@georgehennen/subscribe