05. Formulas/Formulae?

In order to place content into a cell you can simply type the data you want, so for instance in cell C7 I’d like to have the word Surname, go ahead and write that in C7 and then press “Enter“.

In Cell C8 though, we’re going to start by typing an equals sign “=”:

Whatever you type from here on becomes a “Formula“, it can be mathematical, it can link to other cells, there are a vast amount of things you do with formulae (which is just the plural of “formula“) which we’ll learn throughout this tutorial, for now though, we need to click on “Sheet” and then click on the first cell with a name in it (it should be cell E5):

You will notice that the formula bar shows a reference to that cell you’ve just selected, now that we’ve finished typing a formula in, we can press “Enter” and you should be returned to “Sheet 2” where you will see the student’s name in Cell C8:

So C8 above, is referencing the content that is in Cell E5 over on “Sheet“. If the data changes in “Sheet” Cell E5, then it changes here in “Sheet 2” as well.

Worksheet Naming
All these references to “Sheet” and “Sheet 2” are highlighting how useless those names are for the two worksheets so let’s change them. Simply double click on the name of the worksheet down in it’s tab and a box should pop up for you to change the sheet’s name. Change “Sheet” to “gv” and “Sheet 2” to “Summary“. You will notice that the formula you typed into Cell C8 has automatically changed it’s reference from “Sheet” to “gv“…spreadsheets for the win!

Okay, now you’ve probably noticed that the name that has come across isn’t actually the student’s surname…so how do we extract the student’s surname only?

Leave a Comment

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>