WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Equations in Excel

Equations in Excel

What Do You Mean by Equations in Excel?

Equations in excel are none other than our formulas which we type in cell, to write an equation we start with an equals to sign (=) which excel recognizes as to calculate and then we use variables which are connected with each other with some operators, depending upon the operators we get results, an equation can be both linear or non linear.

Explanation

In an excel equation, we use two things:

  1. Cell References
  2. Operators

Cell references are cells like A1, B1, or range of cells A1:A3 and so on, whereas operators are the basic operators such as + for sum – for subtraction * for multiplication and so on.

Like a calculator, Excel can execute formulas such as addition, subtraction, etc. One of the most useful features of  MS Excel is the ability to calculate using a cell address to represent a value in a cell.

This is the basic definition of the cell reference.

Excel uses both cell reference and basic operators to make an equation.

Equations in Excel..

How to Use Equations in Excel? (with Examples)

To make an equation in excel, we need to keep three things in mind:

  1. Every equation starts with an equals sign.
  2. Excel uses cell addresses as values in excel.
  3. Operators are used to making an equation.
You can download this Equations Excel Template here – Equations Excel Template

Example #1

I have my own monthly budget for the past five months. The budget includes data for rent, food, electricity, credit card, and car.

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
View Course

Equation in Excel Example 1

In the first example, we will create an equation for the sum or addition of the bills for each month.

  • Step #1 – In cell B7, start with typing an equals to sign and add each cell reference from B1 to B6 with a + operator in between.

Equation in Excel Example 1-1

  • Step #2 – When we press enter, we get the total spendings done in Jan month

Equation in Excel Example 1-2

In the above two steps, we used cell references and an operator + for addition, and the equation was created as =B2+B3+B4+B5+B6, which gave us our result.

Also, there is an inbuilt function in excel, which gives us the same result, but it saves us the time of giving each cell reference one at a time.

  • Step #1 – In the cell C7, start with typing an equals to sign and type sum then press Tab; it opens an inbuilt sum function for us.

using SUM Equation in Excel Example 1

  • Step #2 – Now select the range of cells from C2 to C6 and press enter.

using SUM Equation in Excel Example 1-1

This also gives the addition of total money spent in the month of February.

using SUM Equation in Excel Example 1-2

  • Step #3 – Repeat the same process for the month of March April & may get the total money spent for the respective months.

using SUM Equation in Excel Example 1-3

I have my money spent on all the months.

using SUM Equation in Excel Example 1-4

Example #2

The above example was a simple addition using equations. Let us make a complex equation.

This time I want to excel to intimate if my money spent was high or average. If the amount spent in total for five months is above 10000, then it should show as “High” else it should show as “Average.” In this type of equation, the operators used are “If Statement.”

Equation in Excel Example 2

  • Step #1 – First, we need to total the money spent on each bill. In cell G2, we will create an equation for the addition of the money spent on rent for five months. We start by typing an equals sign and type Sum, then press the tab button.

Equation in Excel Example 2-1

  • Step #2 – Select the cell references B2 to F6, and press enter.

Equation in Excel Example 2-2

  • Step #3 – We repeat the same addition equation for each and every bill.

Equation in Excel Example 2-3

  • Step #4 – Now in cell H2, type an equals sign and type If then press Tab.

Example 2-4

  • Step #5 – To better understand the If equation, click on fx in the function address bar, and a dialog box pops up.

Example 2-5

  • Step #6 – In the logical test, we will insert our logic, which is the total of bills is greater than 10000. Select range G2 to G6 and insert operator “>” greater than and type 10000.

Example 2-6

  • Step #7 – If the value is true means the total is greater than 10000, we want it to show as high else average.

Example 2-7

  • Step #8 – As we are giving excel value in the string, to start and end it with inverted commas. Click on ok.

Example 2-8

  • Step #9 – Drag the formula to cell H6, and we have our final output.

Example 2-9

In the above example, we have used cell references and If statement as an operator to make an equation.

Things to Remember

  1. Always remember to start an equation with an equals sign.
  2. Creating an equation with cell reference is useful because we can update our data without having to rewrite the formula.
  3. Excel will not always tell us if our equation is wrong or not. So it’s up to us to check all of our equations.

Recommended Articles

This has been a guide to Equations in Excel. Here we discuss how to create simple formulas in excel using examples of SUM and IF Formula in excel and downloadable excel templates. You may also look at these useful excel tools –

  • Two-Variable Data Table in Excel
  • Excel Dynamic Named Range
  • Sentence Case in Excel
5 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download Equations Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More