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
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
Copyright © www.teach-ict.com