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

Download Adobe premiere Pro with Keyboard shortcut key

Image
Adobe Premiere pro Download with  keyboard shortcut key Smart tools. Better storytelling Premiere Pro is the industry-leading video editing software for film, TV and the web. Creative tools, integration with other apps and services and the power of Adobe Sensei help you craft footage into polished films and videos. With Premiere Rush you can create and edit new projects from any device. Click here to Download 👇 Also included with your Adobe Creative  Cloud membership: C lick here to Download keyboard shortcuts for adobe premiere pro Get 2 GB of cloud storage, free mobile apps, fonts from Adobe Fonts and file sharing features. Manage app updates, files, fonts and more with the Creative Cloud desktop app. Browse hundreds of video tutorials for every skill level.
Read more

Keyboard Shortcut key

Image
ESC - Cancel F1 -    Help F2 - Rename  F3 - open search Box (Browser) F4 - skip programme F5 - Refresh F6 - Tab Switch between Desktop and taskbar F7 - spell check & Grammar check (MS- word) F8 - windows startup menu F9 - Compile the program F10- open Menu bar F11 - Activate the fullscreen (Browser) F12 - open save as dialogue box(MS-WORD) Ctrl+A - select All Ctrl+B - Bold text Ctrl+C - Copy Ctrl+D - Open the font preferences window Ctrl+E - center taxt Ctrl+F - Find Ctrl+G - specificed page/ Go to Ctrl+H - Find / Replace Ctrl+I - italicize text Ctrl+J - Full justify Ctrl+K - inser hyperlink Ctrl-Aligns the line or selected text to the left of the screen Ctrl- indent the paragraph Ctrl+N - open new Document Ctrl- open Document Ctrl+P - print Ctrl+Q -Align text left Ctrl+R - Right align text Ctrl- save Document Ctrl- create hanging indent Ctrl+U - underline Ctrl+V - paste Ctrl+W - Close the currently docume...
Read more

How to Make a USB Bootable.

Image
How to Make a  USB Bootable Method 1: Using Command Prompt on Windows 1 Insert a USB flash drive into your computer.  Your USB flash drive should plug into one of the rectangular USB ports on your computer's housing. Flash drives only fit one way, so don't force the drive if it doesn't fit. The USB flash drive should be at least 8 gigabytes in space so that it can accommodate most operating system installation files. 2 Open Start  .  Click the Windows logo in the bottom-left corner of the screen. 3 Type in  command prompt .  This will search your computer for the Command Prompt program. 4 Right-click Command Prompt  .  It's a black box at the top of the Start window. This will prompt a drop-down menu. If your mouse doesn't have a right-click button, click the right side of the mouse, or use two fingers to click the mouse. If your computer uses a trackpad instead of a mouse, use two fingers to ta...
Read more