Here are ten basic Excel formulas:

SUM: This formula adds up a range of cells. For example, =SUM(A1:A10) adds up the values in cells A1 through A10.

AVERAGE: This formula calculates the average of a range of cells. For example, =AVERAGE(A1:A10) calculates the average of the values in cells A1 through A10.

COUNT: This formula counts the number of cells in a range that contain numeric values. For example, =COUNT(A1:A10) counts the number of cells in cells A1 through A10 that contain numbers.

MIN: This formula finds the smallest value in a range of cells. For example, =MIN(A1:A10) finds the smallest value in cells A1 through A10.

MAX: This formula finds the largest value in a range of cells. For example, =MAX(A1:A10) finds the largest value in cells A1 through A10.

IF: This formula performs a logical test and returns one value if the test is true and another value if the test is false. For example, =IF(A1>10,"Yes","No") tests if the value in cell A1 is greater than 10, and returns "Yes" if it is true and "No" if it is false.

CONCATENATE: This formula joins two or more text strings together. For example, =CONCATENATE("John"," ","Doe") joins the text strings "John", " ", and "Doe" to form "John Doe".

LEFT: This formula returns a specified number of characters from the beginning of a text string. For example, =LEFT(A1,3) returns the first three characters of the text string in cell A1.

RIGHT: This formula returns a specified number of characters from the end of a text string. For example, =RIGHT(A1,3) returns the last three characters of the text string in cell A1.

VLOOKUP: This formula searches for a value in the first column of a table and returns a corresponding value in a specified column. For example, =VLOOKUP(A1,Table1,2,FALSE) searches for the value in cell A1 in the first column of Table1, and returns the corresponding value in the second column of Table1.

## Comments