Basic formulas Microsoft Excel

Basic Computer Knowledge

Basic formulas Microsoft Excel

• SUM:

Adds up a range of cells.

For example, “=SUM(A1:A5)” will add the values in cells A1, A2, A3, A4, and A5.

• AVERAGE:

Calculates the average of a range of cells.

For example, “=AVERAGE(A1:A5)” will give you the average of the values in cells A1 to A5.

• MAX:

Returns the highest value in a range of cells.

For example, “=MAX(A1:A5)” will give you the maximum value from cells A1 to A5.

• MIN:

Returns the lowest value in a range of cells.

For example, “=MIN(A1:A5)” will give you the minimum value from cells A1 to A5.

• COUNT:

Counts the number of cells in a range that contains numbers.

For example, “=COUNT(A1:A5)” will give you the count of cells in the range A1 to A5 that contain numbers.

• COUNTA:

Counts the number of cells in a range that are not empty.

For example, “=COUNTA(A1:A5)” will give you the count of cells in the range A1 to A5 that are not empty.

• IF:

Performs a logical test and returns different values depending on the result.

For example, “=IF(A1>10, “Yes”, “No”)” will check if the value in cell A1 is greater than 10 and return “Yes” if true and “No” if false.

• CONCATENATE:

Joins two or more strings of text together.

For example, “=CONCATENATE(A1, ” “, B1)” will combine the text in cells A1 and B1 with a space in between.

• TODAY:

Returns the current date.

For example, “=TODAY()” will give you the current date.

• NOW:

Returns the current date and time.

For example, “=NOW()” will give you the current date and time