EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel Calculations

Home » Excel » Blog » Excel Formula and Functions » Excel Calculations

excel calculation 1-1

Excel Calculations (Table of Contents)

  • Introduction to Excel Calculations
  • How to Calculate Basic Functions in Excel?

Introduction to Excel Calculations

Excel is used for a variety of functions but the basic area why excel was introduced was for handling calculations of day to day work. Like adding, subtracting, multiplication, etc. numbers used for different purposes for a different domain. Though there are other tools for basic calculations but standoff of using excel is its flexibilities and the perception for viewer it gives, for instance, we can add two numbers in calculator as well but the numbers mentioned in the excel sheet can be entered in two cells and used for other functions as well subtraction, division, etc.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Let’s have a quick look at some of the calculations to get a better understanding.

How to Calculate Basic Functions in Excel?

Let us start with the basic calculations and gradually will move further.

You can download this Excel Calculations Template here – Excel Calculations Template

basic calculation 1

List of calculations that one already knows.

basic calculation 2

After using the above formula output shown below.

basic calculation 3

Similarly, a formula used in Cell C3, C4, C5.

basic calculation 4

#1 – MOD

Use to get remainder of two numbers when divided.

Excel Calculations -mod function 1

Apply the MOD formula in cell C2.

Excel Calculations -mod function 2

After using the MOD Formula output is shown below.

Excel Calculations -mod function 3

#2 – Average

Use to take the median or average between the range of numbers.

Excel Calculations -average function 1

Apply the Average formula in cell C2.

Excel Calculations -average function 2

After using the AVERAGE Formula output shown below.

Excel Calculations -average function 3

#3 – Count

Use to count number of cells in data.

Excel Calculations -count function 1

Apply the COUNT formula in Cell C2.

Excel Calculations -count function 2

After using the COUNT Formula output shown below.

Excel Calculations -count function 3

#4 – Abs

Use for removing the sign from the number

Excel Calculations - ABS function 1

Apply the ABS formula in Cell C2.

Excel Calculations - ABS function 1

After using the ABS Formula output shown below.

Excel Calculations - ABS function 2

Note: Abs function can only be used for one cell at a time.

#5 – Concatenate

Use for merging text from two or more cells.

Excel Calculations - concatenate function 1

Apply the Concatenate formula in Cell C2.

Excel Calculations - concatenate function 2

After using the CONCATENATE Formula output as shown below.

concatenate function 2

#6 – Text Join

Use for merging text from two or more cells if one has a range this formula is recommended, though this is a new formula and may not be available in previous versions.

text join function 3

Apply the Concatenate formula in Cell C2.

text join 1

After using the CONCATENATE Formula output is shown below.

text join function 2

#7 – IFS

Use instead of IF condition when there are two many conditions to be given, i.e. nested if-else.

Popular Course in this category
Excel Training (18 Courses, 9+ Projects)18 Online Courses | 9 Hands-on Projects | 95+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (6,672 ratings)
Course Price

View Course

Related Courses
Excel Advanced Training (14 Courses, 23+ Projects)Excel Data Analysis Training (12 Courses, 8+ Projects)

IFS function 3

Apply the IFS formula in Cell C2.

IFS function 1

After using the IFS Formula output is shown below.

IFS function 2

#8 – VLOOKUP

VLOOKUP function is used in various situations such as comparing data with one column and validating whether the data is present in the current column. Retrieving the data of dependent column by comparing the data of the current column with the column which dependent column depends on, for this below is the example for one’s reference.

Explanation: The “Third column Empid” data is first compared with Empid and respect to the “Empid” the name is retrieved in “Result” column. For Example 10203 from “Third column Empid” is compared with “Empid” column i.e.with 10203 and the corresponding name Sanket is retrieved in the “Result” column.

vlookup function 4

Apply the VLOOKUP formula in cell C2.

vlookup function 1

After using the VLOOKUP Formula output is shown below.

vlookup function 2

After using the VLOOKUP Formula output is shown below.

vlookup function 3

Note: Lookup can be used for different application like checking whether the third column is present in the Empid column and so on.

#9 – MID

Use for splitting the text or in easy terms can be used as a substring.

mid function 9

Apply the MID formula in Cell C2.

mid function 1

After using the MID Formula output shown below.

mid function 2

#10 – LEFT

Use the LEFT function when you want to extract characters starting at the left side of the text.

left function 3

Apply the LEFT formula in cell C2.

left function 1

After using the LEFT Formula output is shown below.

left function 2

#11 – RIGHT

Use the RIGHT function when you want to extract characters starting at the right side of the text.

right function 3

Apply the RIGHT formula in Cell C2.

right function 1

After using the RIGHT Formula output is shown below.

right function 2

Explanation: In the above example, from the text value JamesPune we only need James so we use the MID function to split the JamesPune to James as shown in the formulae column. Same goes with a LEFT function where one can use it to split the string from the left side and RIGHT function to split the string from the right side as shown in the formulae.

Note: MID, LEFT and RIGHT function can be also used with a combination such as with Find function, etc.

#12 – FIND

Use for searching the character’s position in the string.

find function 3

Apply the FIND formula in cell C2.

find function 1

After using the FIND Formula output is shown below.

find function 2

#13 – LEN

Use for checking the length of the string.

len function 3

Apply the LEN formula in cell C2.

len function 1

After using the LEN Formula output is shown below.

len function 2

Explanation: FIND function is used for searching the character’s position in the string like the letter “t” position in the above text is at 6 position. LEN in the above example gives the length of the string

#14 – PMT

It is used for calculation of monthly installments one has to pay.

PMT function 3

Apply the PMT formula in cell C2.

PMT function 1

After using the PMT Formula output is shown below.

PMT function 2

#15 – Nested Formula

Used when our conditions have two to three functions to be used. Suppose we have a text Sau; Mumbai;27 and we want to separate as the Name then we would following formula as =MID(A2,1,FIND(“;”,A2,1)-1).

nested function 1

Apply the MID formula in cell C2.

mid function 3

After using the above Formula output shown below.

mid function 4

mid function 5

After using the above Formula output is shown below.

mid function 6

mid function 7

After using the above Formula output is shown below.

mid function 8

Explanation:

So here for Name we only want “Sau”, so here we use the combination of MID function which will help us to split the string and the FIND function helps to locate the position of ; in the string, i.e.as per MID function it needs:

MID(Text_value,start_position, end_position)

Text_value: Sau;Mumbai;27

Start_position: 1

End_position: Position of the first semicolon by FIND function

FIND (find_text, within_text, [start_num])

Find_text = ;

Within_text= Sau;Mumbai;27

Start_num=1

So here the FIND function gives position as 4 and hence the MID function looks like this MID(A98,1,4-1) ie. MID(A98,1,3) which would result in “Sau” as shown in below fig:

Pros

  • The excel calculations provide a robust function.
  • Calculations can be dynamic.
  • Nested Functions are possible.
  • The more functions are getting added up helping users to get as much ease and avoid more usage of Nested Formulae Example: PMT formula.

Cons

  • Nested Formulae becomes complex to apply
  • Sometimes maintenance and usage of the formulae becomes difficult if the user is not prone to excel

Things to Remember About Excel Calculations

  • Save your worksheet after every application of excel calculations
  • Functions of excel are getting added up day by day, so it’s good to stay updated and avoiding usage of Nested Formulae
  • Whenever one applies the function in the excel, one can click on Tab button to autocomplete the Function name i.e. if one wants to enter Sum function in a cell then choose the cell and write “ = S” and press Tab the function would get autocompleted and one can also see the value which the function ask for

Recommended Articles

This is a guide to Excel Calculations. Here we discuss How to Calculate Basic Functions in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Count Names in Excel
  2. NPV Formula in Excel
  3. Mixed Reference in Excel
  4. VBA Right | Excel Template

Excel Training (18 Courses, 9+ Projects)

18 Online Courses

9 Hands-on Projects

95+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

3 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Formula and Functions
    • VLOOKUP Names
    • Advanced Formulas in Excel
    • Excel Function for Range
    • Excel Sum Time
    • Payroll in Excel
    • Complex Formulas in Excel
    • Pivot Chart in Excel 2016
    • Advanced Excel Formulas
    • Best Basic Excel Formulas
    • Use Excel As Your Calculator
    • Print Command Button in Excel
    • Excel SUM MAX MIN AVERAGE
    • Excel Basic Functions For Beginners
    • Interactive Excel Dashboard
    • Features of 2016 Excel Workbook
    • What's New In Excel 2016
    • Microsoft Excel Skills
    • Microsoft Excel Shortcuts
    • Microsoft Excel Tips and Tricks
    • Excel Skills
  • Excel Functions (12+)
  • Excel Tools (110+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (13+)
  • Lookup Reference Functions in Excel (33+)
  • Maths Function in Excel (46+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (22+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Charts (55+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Excel Training
  • Excel Advanced Training
  • Excel Data Analysis Training
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download Excel Calculations Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - Excel Training (18 Courses, 9+ Projects) Learn More