This formula allows you to add up a range of numbers. For example, =SUM(A1:A10) adds up the values in cells A1 through A10.
This formula calculates the average of a range of numbers. For example, =AVERAGE(B1:B5) calculates the average of the values in cells B1 through B5.
This formula returns the maximum value in a range of numbers. For example, =MAX(C1:C10) returns the highest value in cells C1 through C10.
This formula returns the minimum value in a range of numbers. For example, =MIN(D1:D15) returns the lowest value in cells D1 through D15.
This formula counts the number of cells that contain numbers within a range. For example, =COUNT(E1:E20) counts the number of cells in E1 through E20 that contain numbers.
This formula allows you to create conditional statements. For example, =IF(F1>10, "Yes", "No") will return "Yes" if the value in cell F1 is greater than 10, and "No" if it is not.
This formula joins two or more strings of text together. For example, =CONCATENATE("Hello ", "world!") returns "Hello world!"
This formula searches for a value in the first column of a table, and returns a corresponding value from a specified column in the same row. For example, =VLOOKUP(G1, A1:B10, 2, FALSE) searches for the value in cell G1 in the first column of the table A1 through B10, and returns the corresponding value in the second column of the same row.
This formula returns the value of a cell at a specific row and column in a range. For example, =INDEX(C1:F10, 5, 3) returns the value in the fifth row and third column of the range C1 through F10.
This formula rounds a number to a specified number of decimal places. For example, =ROUND(3.14159, 2) rounds the number 3.14159 to two decimal places, resulting in 3.14.