BASIC FUNCTIONS / FORMULAS OF MS EXCEL

 There are many basic formulas in Microsoft Excel that you can use to perform calculations and analysis on your data. Here are some of the most commonly used ones:

SUM: Adds up a range of numbers. The formula syntax is "=SUM(range)". & "=A1 + B1"

SUBTRACT: Devides one cell value from other. The formula syntax is "=A1-B1".

Devide: Devides one cell value with other. The formula syntax is "=A1/B1".

MULTIPLY: Multiplies one Cell value with Other. The formula syntax is "=A1*B1".

AVERAGE: Calculates the average of a range of numbers. The formula syntax is "=AVERAGE(range)".

MAX: Returns the largest value in a range of numbers. The formula syntax is "=MAX(range)".

MIN: Returns the smallest value in a range of numbers. The formula syntax is "=MIN(range)".

COUNT: Counts the number of cells in a range that contain numbers. The formula syntax is "=COUNT(range)".

IF: Tests a condition and returns one value if the condition is true and another value if the condition is false. The formula syntax is "=IF(condition, value_if_true, value_if_false)".

VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from a specified column. The formula syntax is "=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])".

CONCATENATE: Joins two or more text strings into one string. The formula syntax is "=CONCATENATE(text1, [text2], [text3], ...)" or "=CONCATENATE(A1, B1, C1, ...)". assuming A1, B1 & C1 contain texts 1, 2 & 3.

LEFT: Extracts a specified number of characters from the beginning of a text string. The formula syntax is "=LEFT(text, num_chars)" or = "LEFT(A1, num_chars)" assuming A1 contains the text.

RIGHT: Extracts a specified number of characters from the end of a text string. The formula syntax is "=RIGHT(text, num_chars)". or = "RIGHT(A1, num_chars)" assuming A1 contains the text.

These are just a few examples of the many formulas available in Microsoft Excel. By mastering these basic formulas, you can perform a wide range of calculations and analysis on your data.