List of Top 10 Basic Excel Formulas & Functions

 

Basic Excel Formulas

List of Top 10 Basic Excel Formulas & Functions

Here is the list of Top 10 Basic Formulas & Functions in Excel.

  1. SUM
  2. COUNT
  3. COUNTA
  4. COUNTBLANK
  5. AVERAGE
  6. MIN Excel
  7. MAX Excel
  8. LEN Excel
  9. TRIM Excel
  10. IF Excel

Now let us discuss each of them in detail –

You can download this Basic Formulas Excel Template here – Basic Formulas Excel Template

Basic Excel Functions

#1SUM in Excel

This Basic Excel Formula is used to get the sum of the value in one or more cells or Range.

Basic Sum Function Formula

Example

=SUM(A1:A5) 

Basic Sum Function Example 1

Result = 41 (See Image below)

Basic Sum Function Example 1-1

#2COUNT Excel Function

This Basic Excel Function is used to Count the numeric value in one or more cells or Range.

Basic Count Formula

Example

=COUNT(A1:A5)

Basic Count Example 2

Result = 4 (This will exclude Cell A3 since this formula calculate only Numeric value. See Image below)

Basic Count Example 2-1

#3COUNTA 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)

Basic COUNTA Formula

Example

=COUNTA(A1:A5)

Basic COUNTA Example 3

Result = 5 (This will Include Cell A3 since this formula calculate both Text and Numeric value. See Image below)

 Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

Basic COUNTA Example 3-1

#4COUNTBLANK 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).

Basic COUNTBLANK Formula

Example

=COUNTBLANK(A1:A5)

Basic COUNTBLANK Example 4

Result = 2 (This will calculate the number of blank cell in Range. See Image below)

Basic COUNTBLANK Example 4-1

#5AVERAGE in Excel

This basic formula in excel is used to get the average of the value in one or more cells or Range.

Basic Average Formula

Example

=AVERAGE(A1:A5) 

Basic Average Example 5

Result = 4 (See Image below)

Basic Average Example 5-1

#6MIN Formula in Excel

This excel basic function is used to get the minimum value in cells or Range.

Basic Min Formula

Example

=MIN(A1:A5). Result = 2 (See Image below)

Basic Min Example 6

Basic Min Example 6-1

#7MAX Formula in Excel

This basic excel function is used to get the maximum value in cells or Range.

Basic Max Formula

Example

=MAX(A1:A5)

Basic Max Example 7

Result = 9 (See Image below)

Basic Max Example 7-1

#8LEN in Excel

This basic function excel is used to calculate the number of characters in a cell or Text.

Basic Len Formula

Example

=LEN(A1)

Basic Len Example 8

Cell A1 value is Shivam, which has 6 Character length. So Result would be 6 (See Image below)

Basic Len Example 8-1

#9TRIM in Excel

This basic excel function is used to remove unnecessary space in a cell or Text.

SYNTAX: TRIM(TEXT)

Basic Trim Formula

Example

=TRIM(A1)

Basic Trim Example 9

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)

Basic Trim Example 9-1

#10IF in Excel

IF function is used to perform a logical test in excel.

Basic IF Formula

Example

=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.

Basic IF Example 10

Since the value 50 is greater than 33, the result would be P. (See Image below)

Basic IF Example 10-1

Comments

Post a Comment

Popular posts from this blog

How to enter the BIOS or CMOS setup Updated:  12/30/2019  by  Computer support 19 Because of the wide variety of computer and BIOS manufacturers over the evolution of computers, there are numerous ways to enter the  BIOS  or  CMOS  setup. Below is a listing of most of these methods, as well as other recommendations for entering the BIOS setup. Note Apple (Mac) computers don't have a BIOS and instead utilize an  EFI , which does not need to modify based on the hardware in the computer, like a BIOS. The EFI provides better integration between hardware and software for Apple computers, virtually eliminating the need for a BIOS. Note This document does not help if you  cannot enter the CMOS setup because it is password-protected . New computers Computers manufactured in the last few years allow you to enter the BIOS setup using one of the five keys shown below during the  boot  process. F1 F2 * F10 ** Del Esc ...
Read more

BIOS- CMOS

Image
BIOS Short for Basic Input/Output System, BIOS is a chip located on all computer motherboards that contains instructions and setup for how your system should boot and how it operates. BIOS is chip level program, using which we can configure the basic input and output system of our computer. The BIOS may be different for different computers depending on the manufacturer. CMOS CMOS is short for Complementary Metal-Oxide Semiconductor. CMOS is an on-board semiconductor chip powered by a CMOS battery inside computers that stores information such as system time and system settings for your computer. How to enter the BIOS or SMOS setup? You can enter the BIOS or CMOS by pressing any one of the for keys (F1, F2, F10, Del) during the boot. BIOS operations In BIOS we can view the overall device configurations, change system date and time, configure the boot device priority, set supervisor password and even load optimal defaults to all devices. Boot Device Priority The boot de...
Read more

The Google Chrome Keyboard Shortcuts

The Google Chrome Keyboard Shortcuts Windows/Linux Shortcut Mac Shortcut Action Navigating Tabs and Windows Ctrl + N Cmd + N Open new window Ctrl + Shift + N Cmd + Shift + N Open new incognito window Ctrl + T Cmd + T Open new tab Ctrl + W Cmd + W Close current tab Ctrl + Shift + W Cmd + Shift + W Close current window Ctrl + Shift + T Cmd + Shift + T Reopen last closed tab Ctrl + 1 — Ctrl + 8 Cmd + 1 — Cmd + 8 Switch to tab 1-8 Ctrl + 9 Cmd + 9 Switch to last tab Ctrl +Tab Cmd + Option + Right Move to next tab Ctrl + Shift + Tab Cmd + Option + Left Move to prior tab Ctrl + Click Cmd + Click Open link in a new tab Ctrl + Shift + Click Cmd + Shift + Click Open link in a new tab and switch to it immediately Shift + Click Shift + Click Open link in a new window Alt + Left Cmd + [ Go back one page Alt + Right Cmd + ] Go forward one page Alt + Home Cmd + Shift + H Open your homepage in the current tab Ctrl + Shift + Q Cmd + Q Quit Chrome General Chrome Functions Ctr...
Read more