Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Equations is excel is none other than our formulas which we type in excel 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 in excel can be both linear or non linear.
Equations in Excel (Table of Contents)
Equations in Excel
A formula is an equation which performs a calculation. Like normal calculations, excel uses formulas or equations to perform a different type of calculations.
We can use excel as our calculator and perform calculations like subtraction, addition, sum average or other complex calculations. How we do this by making equations in excel or formulas. To make an equation or formula in excel first we type an equals to sign in a cell which is a start of a formula.
As long as we understand the basics the mathematical operations or the logics excel does a lot of work for us.
In an excel equation we use two things:
- Cell References
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.
Explanation of Equations in Excel
Like a calculator, excel can execute formulas such as addition subtraction etc. One of the most useful features of 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.
How to Use Equations in Excel?
To make an equation in excel we need to keep three things in mind:
- Every equation starts with an equals to sign.
- Excel uses cell addresses as values in excel.
- Operators are used to making an equation.
Let us make some excel equations with few examples.
Equations in Excel Example #1 (Using SUM Formula)
I have my own monthly budget for the past five months. The budget includes data for rent, food, electricity, credit card, and car.
In the first example, we will create an excel equation for sum or addition of the bills for each month.
#1 – In cell B7 start with typing an equals to sign and add each cell references from B1 to B6 with a + operator in between.
#2 – When we press enter we get the total spendings done in Jan month
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.
#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.
#2 – Now select the range of cells from C2 to C6 and press enter.
This also gives the addition of total money spent in the month of February.
#3 – Repeat the same process for the month of March April & may get the total money spent for the respective months.
I have my money spent for all the months.
Now we have learned to give cell reference column wise let us do it in the rows. I want to know how much money I have spent in total in all these five months.
In a blank cell start typing an equals to sign and sum then press the tab button.
Select cells B7 to F7 for the data range and press enter.
I have my total money spent on all the months.
Equations in Excel Example #2 (Using SUM & IF Formula)
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 than 10000 then it should show as “High” else it should show as “Average”. In this type of equations, the operators used is “If Statement”.
#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.
#2 – Select the cell references B2 to F6, and press enter.
#3 – We repeat the same addition equation for each and every bill.
#4 – Now in cell H2, type an equals sign and type If then press Tab.
#5 – To better understand If equation in excel click on fx in the function address bar and a dialog box pops up.
#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.
#7 – If the value is true means total is greater than 10000 we want it to show as high else average.
#8 – As we are giving excel value in the string so we to start and end it with inverted commas. Click on ok.
#9 – Drag the formula to cell H6 and we have our final output.
In the above example, we have used cell references and If statement as an operator to make an equation.
Things to Remember
- Always remember to start an equation with an equals to sign.
- Creating an equation with cell reference is useful because we can update our data without having to rewrite the formula.
- 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.
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 –