Formula Description Example
=SUM(A1:A5) adds the values in
SUM Adds a range of numbers together. cells A1 through A5.
=AVERAGE(A1:A5) calculates the
Calculates the average of a range of average of the values in cells A1
AVERAGE numbers. through A5.
=COUNT(A1:A5) counts the number
Counts the number of cells in a range of cells in the range A1 through A5
COUNT that contain numbers. that contain numbers.
Finds the maximum value in a range of =MAX(A1:A5) finds the highest value
MAX numbers. in the range A1 through A5.
Finds the minimum value in a range of =MIN(A1:A5) finds the lowest value
MIN numbers. in the range A1 through A5.
=B1 / 15% –Finds the value 15%of
PERCENTAGE Calculates the percentage of a number. B1 by calculating.
Divides one number by another =D1 / 2 – Finds the value
DIVIDE number. of D1 divided by 2.
Multiplies two or more numbers
MULTIPLY together. =A1 * B1 – Multiplies A1 with B1.
=CONCATENATE(“Hello
“,”world!”) joins the two text strings
CONCATENATE Joins two or more text strings into one. to create the sentence “Hello world!”.
Returns a specified number of
characters from the beginning of a text =LEFT(A1,3) returns the first three
LEFT string. characters of the text string in cell A1.
Returns a specified number of
characters from the end of a text =RIGHT(A1,3) returns the last three
RIGHT string. characters of the text string in cell A1.
Returns a specified number of =MID(A1,3,5) returns five characters
characters from the middle of a text starting from the third character of
MID string. the text string in cell A1.
Rounds a number to a specified =ROUND(A1,2) rounds the value in
ROUND number of decimal places. cell A1 to two decimal places.
Rounds a number up to a specified =ROUNDUP(A1,2) rounds the value
ROUNDUP number of decimal places. in cell A1 up.
Rounds a number down to a specified =ROUNDDOWN(A1,2) rounds the
ROUNDDOWN number of decimal places. value in cell A1 down.
Removes excess spaces from a text =TRIM(A1) removes excess spaces
TRIM string. from the text string in cell A1.
Returns the number of characters in a =LEN(A1) returns the number of
LEN text string. characters in the text string in cell A1.
=NOW() returns the current date and
NOW Returns the current date and time. time.
TODAY Returns the current date. =TODAY() returns the current date.
Returns the date that corresponds to a
specified set of year, month, and day =DATE(2022,12,31) returns
DATE values. December 31, 2022.
Returns the last day of the month that
is a specified number of months before =EOMONTH(A1,3) returns the last
EOMONTH or after a given date. day of the month.
