Microsoft Excel 2019 15 basic formulas

 

Here are 15 basic formulas in Excel 2019:

1.   SUM: This formula is used to add up a range of numbers.

Syntax: =SUM(number1,number2,...)

Example: =SUM(A1:A10)

 

2.   AVERAGE: This formula is used to calculate the average of a range of numbers.

Syntax: =AVERAGE(number1,number2,...)

Example: =AVERAGE(A1:A10)

 

3.   MAX: This formula is used to find the largest number in a range.

Syntax: =MAX(number1,number2,...)

Example: =MAX(A1:A10)

 

4.   MIN: This formula is used to find the smallest number in a range.

Syntax: =MIN(number1,number2,...)

Example: =MIN(A1:A10)

 

5.   COUNT: This formula is used to count the number of cells that contain numbers in a range.

Syntax: =COUNT(number1,number2,...)

Example: =COUNT(A1:A10)

 

6.   COUNTA: This formula is used to count the number of cells that contain any type of data (numbers, text, formulas, etc.) in a range.

Syntax: =COUNTA(value1,value2,...)

Example: =COUNTA(A1:A10)

 

7.   ROUND: This formula is used to round a number to a specified number of decimal places.

Syntax: =ROUND(number,num_digits)

Example: =ROUND(A1,2)

 

8.   IF: This formula is used to test a condition and return one value if the condition is true and another value if the condition is false.

Syntax: =IF(condition,value_if_true,value_if_false)

Example: =IF(A1>10,"Yes","No")

 

9.   SUMIF: This formula is used to add up values in a range that meet a specified criterion.

Syntax: =SUMIF(range,criteria,sum_range)

Example: =SUMIF(A1:A10,">10",B1:B10)

 

10.         AVERAGEIF: This formula is used to calculate the average of values in a range that meet a specified criterion.

Syntax: =AVERAGEIF(range,criteria,average_range)

Example: =AVERAGEIF(A1:A10,"Apples",B1:B10)

 

11.         TRIM: This formula is used to remove extra spaces from text.

Syntax: =TRIM(text)

Example: =TRIM(" Apple ")

 

12.         LEFT: This formula is used to extract a specified number of characters from the beginning of a text string.

Syntax: =LEFT(text,num_chars)

Example: =LEFT("Apple",3)

 

13.         RIGHT: This formula is used to extract a specified number of characters from the end of a text string.

Syntax: =RIGHT(text,num_chars)

Example: =RIGHT("Apple",2)

 

14.         LEN: This formula is used to count the number of characters in a text string.

Syntax: =LEN(text)

Example: =LEN("Apple")

 

15.         CONCATENATE: This formula is used to join two or more text strings into one.

Syntax: =CONCATENATE(text1, text2, ...)

Example: =CONCATENATE("John ","Doe")