Bitesize has changed! We're updating subjects as fast as we can. Visit our new site to find Bitesize guides and clips - and tell us what you think!
Print

DiDA

Spreadsheets

Calculations using simple formulae

Below is a spreadsheet showing the cost of computer equipment from three shops.

spreadsheet showing computer costs

A spreadsheet showing the cost of computer equipment from three shops

You can use a simple addition formula to find out how much a computer and printer from Shop 1 would cost.

  • price of computer = cell B2
  • price of printer = cell D2
  • the formula to add these two together is B2 + D2

Type in = B2+D2

spreadsheet of computer costs with a simple formulae highlighted

Sum (= B2+D2)

All formulae in spreadsheets need to begin with the = sign. This tells the cell to expect a formulae.

Other simple formulae you should know are listed in the table below.

Spreadsheet formulae.

CalculationSymbolExample
Subtract-=A1-A2
Multiply*=A1*A2
Divide/=A1/A2
Percentage% =A1%17.5%

Back to Using ICT index

BBC © 2014 The BBC is not responsible for the content of external sites. Read more.

This page is best viewed in an up-to-date web browser with style sheets (CSS) enabled. While you will be able to view the content of this page in your current browser, you will not be able to get the full visual experience. Please consider upgrading your browser software or enabling style sheets (CSS) if you are able to do so.