2. Variables

DEFINITION:

A variable holds values which can change. 

In order to set up a model, you need to be able to change parts of it in order to see what effect that has on the overall result.

This is what a variable can do for you - a variable allows you to change the model that then re-calculates the result.

The simplest kind of variable is a single cell containing a number

what is variable

Cell A1 and A2 are 'variables', because if you change their values, the result in A3 will change. So the simplest kind of variable is a single cell reference.

 

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Spreadsheet Variables