ComputingRevision.net

Basic Spreadsheet Formula

The simplest way to use Excel is perform calculations on two or more cells and output the result in another cell.

Maths Operators

Spreadsheets can perform calculations between two or more cells, showing the result in another cell. If you change the original numbers, the results automatically updates. Very useful!

Adding

You are going to add the numbers in A2 and B2 and show the result in D2.

  1. Click D2
  2. Type = (do not press enter yet)
  3. Click A2
  4. Type +
  5. Click B2
  6. Press Enter

The total, 76, will be shown in D2.

Now try the others

  1. Row 3: subtract using the - symbol
  2. Row 4: multiply using the * (asterisk) symbol
  3. Row 5: divide using the / symbol

Calculations on Multiple Cells

You can use lots of cells in one big calculation. Excel follows BODMAS rules, so use brackets if you need one part of a calculation to be done first.

◀︎ Spreadsheet Terminology
▲︎
Spreadsheet Functions ▶︎