Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts

Table Pivot

Table Pivot Intro

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR

Excel How To

Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates

Guided Projects

Introduction to Excel Learn Data Calculations Learn Data Visualization Learn to Create a Budget Learn to Create a Timeline Learn to Style in Excel

Excel Examples

Excel Exercises Excel Certificate

Excel References

Excel Keyboard Shortcuts


Excel Syntax


Syntax

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign = typed in the cell, followed by your calculation.

Note: You claim the cell by selecting it and typing the equal sign (=)

Creating formulas, step by step

  • Select a cell
  • Type the equal sign (=)
  • Select a cell or type value
  • Enter an arithmetic operator
  • Select another cell or type value
  • Press enter

For example =1+1 is the formula to calculate 1+1=2

Note: The value of a cell is communicated by reference(value) for example A1(2)


Using Formulas with Cells

You can type values to cells and use them in your formulas.

Lets type some dummy values to get started. Double click the cells to type values into them. Go ahead and type:

  • A1(309)
  • A2(320)
  • B1(39)
  • B2(35)

Compare with the picture shown below:

Copy Values

Note: Type values by selecting a cell, claim it by entering the equal sign (=) and then type your value. For example =309.

Well done! You have successfully typed values to cells and now we can use them to create formulas.

Here is how to do it, step by step.

  1. Select the cell C1
  2. Type the equal sign (=)
  3. Left click on A1, the cell that has the (309) value
  4. Type the minus sign (-)
  5. Left click on B2, the cell that has the (35) value
  6. Hit enter

Tip: The formula can be typed directly without clicking the cells. The typed formula would be the same as the value in C1 (=A1-B2).


The result after hitting the enter button is C1(274). Did you make it?



Another Example

Let's try one more example, this time let's make the formula =A2-B1.

Here is how to do it, step by step.

  1. Select the cell C2
  2. Type the equal sign (=)
  3. Left click A2, the cell that has the (320) value
  4. Type the minus sign (-)
  5. Left click B1, the cell that has the (39) value
  6. Hit the enter button

You got the result C2(281), right? Way to go!

Note: You can make formulas with all four arithmetic operations, such as addition (+), subtraction (-), multiplication (*) and division (/).

Here are some examples:

  • =2+4 gives you 6
  • =4-2 gives you 2
  • =2*4 gives you 8
  • =2/4 gives you 0.5

In the next chapter you will learn about Ranges and how data can be moved in the Sheet.

Test Yourself With Exercises

Excel Exercise:

Complete the Excel formula:

1+1

Start the Exercise