EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Calculations in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Calculations in Excel

By Arun GuptaArun Gupta

calculations in excel

How to Calculate in Excel (Table of Contents)

  • Introduction to Calculations in Excel
  • Examples of Calculations in Excel

Introduction to Calculations in Excel

The following article provides an outline for Calculations in Excel. MS Excel is the most preferred option for calculation; most investment bankers and financial analysts use it to do data crunching, prepare presentations, or model data.

Start Your Free Excel Course

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

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

There are two ways to perform the Excel calculation: Formula and the second is Function. Where formula is the normal arithmetic operation like summation, multiplication, subtraction, etc. Function is the inbuilt formula like SUM (), COUNT (), COUNTA (), COUNTIF (), SQRT () etc.

Operator Precedence: It will use default order to calculate; if there is some operation in parentheses, then it will calculate that part first, then multiplication or division after that addition or subtraction. It is the same as the BODMAS rule.

Examples of Calculations in Excel

Here are some examples of How to Use Excel to Calculate Basic calculations.

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

Example #1 – Basic Calculations like Multiplication, Summation, Subtraction, and Square Root

Here we are going to learn how to do basic calculations like multiplication, summation, subtraction, and square root in Excel.

Let’s assume a user wants to perform calculations like multiplication, summation, subtraction by 4 and find out the square root of all numbers in Excel.

Let’s see how we can do this with the help of calculations.

Step 1: Open an Excel sheet. Go to sheet 1 and insert the data as shown below.

calculations in excel example 1.1

Step 2: Now create headers for Multiplication, Summation, Subtraction, and Square Root in row one.

calculations in excel example 1.2

Step 3: Now calculate the multiplication by 4. Use the equal sign to calculate. Write in cell C2 and use asterisk symbol (*) to multiply “=A2*4“

calculations in excel example 1.3

Step 4: Now press on the Enter key; multiplication will be calculated.

calculations in excel example 1.4

Step 5: Drag the same formula to the C9 cell to apply to the remaining cells.

calculations in excel example 1.5

Step 6: Now calculate subtraction by 4. Use an equal sign to calculate. Write in cell D2 “=A2-4“

calculations in excel example 1.6

Step 7: Now click on the Enter key, the subtraction will be calculated.

calculations in excel example 1.7

Step 8: Drag the same formula till cell D9 to apply to the remaining cells.

calculations in excel example 1.8

Step 9: Now calculate the addition by 4, use an equal sign to calculate. Write in E2 Cell “=A2+4“

calculations in excel example 1.9

Step 10: Now press on the Enter key, the addition will be calculated.

calculations in excel example 1.10

Step 11: Drag the same formula to the E9 cell to apply to the remaining cells.

calculations in excel example 1.11

Step 12: Now calculate the square root>> use equal sign to calculate >> Write in F2 Cell >> “=SQRT (A2“

calculations in excel example 1.12

Step 13: Now, press on the Enter key >> square root will be calculated.

calculations in excel example 1.13

Step 14: Drag the same formula till the F9 cell to apply the remaining cell.

calculations in excel example 1.14

Summary of Example 1: As the user wants to perform calculations like multiplication, summation, subtraction by 4 and find out the square root of all numbers in MS Excel.

Example #2 – Basic Calculations like Summation, Average, and Counting

Here we are going to learn how to use Excel to calculate basic calculations like summation, average, and counting.

Let’s assume a user wants to find out total sales, average sales, and the total number of products available in his stock for sale.

Let’s see how we can do this with the help of calculations.

Step 1: Open an Excel sheet. Go to Sheet1 and insert the data as shown below.

calculations in excel example 2.1

Step 2: Now create headers for Result table, Grand Total, Number of Product and an Average Sale of his product in column D.

calculations in excel example 2.2

Step 3: Now calculate grand total sales. Use the SUM function to calculate the grand total. Write in cell E3. “=SUM (“

calculations in excel example 2.3

Step 4: Now, it will ask for the numbers, so give the data range, which is available in column B. Write in cell E3. “=SUM (B2:B11) “

calculations in excel example 2.4

Step 5: Now press on the Enter key. Grand total sales will be calculated.

calculations in excel example 2.5

Step 6: Now calculate the total number of products in the stock, use the COUNT function to calculate the grand total. Write in cell E4 “=COUNT (“

CIE example 2.6

Step 7: Now, it will ask for the values, so give the data range, which is available in column B. Write in cell E4. “=COUNT (B2:B11) “

CIE example 2.7

Step 8: Now press on the Enter key. The total number of products will be calculated.

CIE example 2.8

Step 9: Now calculate the average sale of products in the stock, use the AVERAGE function to calculate the average sale. Write in cell E5. “=AVERAGE (“

CIE example 2.9

Step 10: Now, it will ask for the numbers, so give the data range which is available in column B. Write in cell E5. “=AVERAGE (B2:B11) “

CIE example 2.10

Step 11: Now click on the Enter key. The average sale of products will be calculated.

CIE example 2.11

Summary of Example 2: As the user wants to find out total sales, average sales, and the total number of products available in his stock for sale. 

Things to Remember about Calculations in Excel

  • During calculations, if there are some operations in parentheses, then it will calculate that part first, then multiplication or division after that addition or subtraction.
  • It is the same as the BODMAS rule: Parentheses, Exponents, Multiplication and Division, Addition and Subtraction.
  • When a user uses an equal sign (=) in any cell, it means that the user is going to put some formula, not a value.
  • A small difference from the normal mathematics symbol like multiplication uses asterisk symbol (*) and for division uses forward-slash (/).
  • There is no need to write the same formula for each cell; once it is written, then just copy-paste to other cells, it will calculate automatically.
  • A user can use the SQRT function to calculate the square root of any value; it has only one parameter. But a user cannot calculate square root for a negative number; it will throw an error #NUM!

CIE SQRT function

  • If a negative value occurs as output, use the ABS formula to determine the absolute value, which is an in-built function in MS Excel.
  • A user can use the COUNTA in-built function if there is confusion in the data type because COUNT supports only numeric values.

Recommended Articles

This is a guide to Calculations in Excel. Here we discuss how to use excel to calculate along with examples and a downloadable excel template. You may also look at the following articles to learn more –

  1. Create a Lookup Table in Excel
  2. Use of COLUMNS Formula in Excel
  3. CHOOSE Formula in Excel with Examples
  4. What is Chart Wizard in Excel?
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • 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

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - 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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Calculations Excel Template

EDUCBA

Download Calculations Excel Template

EDUCBA

डाउनलोड Calculations Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more