List of Top 10 Basic Excel Formulas & Functions
Here is the list of Top 10 Basic Formulas & Functions in Excel.
- MIN Excel
- MAX Excel
- LEN Excel
- TRIM Excel
- IF Excel
Now let us discuss each of them in detail –
#1 SUM in Excel
This Basic Excel Formula is used to get the sum of the value in one or more cells or range.
Result = 41 (See Image below)
#2 COUNT Excel Function
This Basic Excel Function is used to Count the numeric value in one or more cells or range.
Result = 4 (This will exclude Cell A3 since this formula calculate only Numeric value. See Image below)
#3 COUNTA in Excel
This Formula is used to count the value in one or more cells (This will count the cells irrespective of Number or Text value)
Result = 5 (This will Include Cell A3 since this formula calculate both Text and Numeric value. See Image below)
#4 COUNTBLANK in Excel
This Excel Basic function is used to count the blank value in the range. (Note: Only Space in a cell will not be considered as a blank cell).
Result = 2 (This will calculate the number of blank cell in Range. See Image below)
#5 AVERAGE in Excel
This basic formula in excel is used to get the average of the value in one or more cells or range.
Result = 4 (See Image below)
#6 MIN Formula in Excel
This excel basic function is used to get the minimum value in cells or Range.
=MIN(A1:A5). Result = 2 (See Image below)
#7 MAX Formula in Excel
This basic excel function is used to get the maximum value in cells or Range.
Result = 9 (See Image below)
#8 LEN in Excel
This basic function excel is used to calculate the number of characters in a cell or Text.
Cell A1 value is Shivam which has 6 Character length. So Result would be 6 (See Image below)
#9 TRIM in Excel
This basic excel function is used to remove unnecessary space in a cell or Text.
Cell A1 has two spaces between first name, middle name, and last name. This function will remove extra space to give the result.(See Image below)
#10 IF in Excel
IF function is a Logical function that is used to perform a logical test in excel.
=IF(A1>33,”P”,”F”). A value in Cell A1 is 50 and a logical test is if the value is greater than 33 then the result would be P else the result would be F.
Since the value 50 is greater than 33, the result would be P. (See Image below)
Things to Remember
- A formula should always start with equal sign else it will show an error
- If you are entering any text value instead of giving cell address then the text value should be given within Inverted Comma (“”)
- Before entering the function in a cell make sure that cell format in general. If a Text format is selected then the formula will not work.
- Space (_) is always counted as a single character so if you are working with blank cells keep this thing in mind that if a cell has only space it will not be counted as a blank cell.
Basic Excel Formulas Video
This has been a guide to Basic Formulas in Excel. Here we discuss the list of top 10 Basic Formulas & Functions in Excel including SUM, COUNT, COUNTA, COUNTBLANK, MAX, MIN, etc with downloadable excel template. You may learn more about excel from the following articles –