**Excel Spreadsheets - Add Formulae**

**Back
to Computer Sharing Skills Index**

# How To Add Formulae?

Look at the example below, a skeleton of a hotel booking
system.

We will now look at how to add formulas. When you type in a
formulae you must always place an **=** equals sign at the start.

The first formulae will multiply two numbers together to work
out the total it will cost a family. This calculation is:-

**(PRICE OF ACCOMMODATION x NO. OF GUESTS) x 7 = TOTAL COST
FOR 7 DAYS**

The formulae for this is** =(E2*F2)*7**

**To do this you would:**

**1)** Type this formula** =(E2*F2)*7 **in cell G2.
(see picture at top of this page - arrow **1**)

**2)** Press Enter

**3)** To copy this down the column you first click once on the formulae, which
has changed to £700 and click on the Copy button on the toolbar.

**4)** Now highlight all the empty cells (your cursor must change to a + cross
first) where you would like the total to be calculated.

**5)** Click the Paste button on the tool bar.

**To work out the profit you would:-**

**1)** Click on an empty cell in column G.

**2)** Then type:- **=SUM(G2:G9)**
(see picture at top of this page - arrow **2**)

**3) **Press Enter.

**4)** Another way to do this is to highlight the whole column and the next empty
cell and then click on the AutoSum
button. (see picture at top of this page -
arrow **3**)

**5)** Press Enter.

**Back to Computer
Sharing Skills Index**

**Guides (c) Paul
Goates**