what is a variable?

Showing 1 to 3 of 3

can someone explain to me what a variable is in terms of spreadsheets, a example would be useful also. thanks

Modified once, last modified by Thegirlwhoknewtoomuch - Team GR on Tue 23rd October, 2012 @ 10:38

Posted: 23-10-12 10:01 by Thegirlwhoknewtoomuch - Team GR

"A variable is something which holds a value and that value can change"

This can be a two cells in a spreadsheet which the values of can be changed, this makes them variable. The variables may lead to a change in the value of a referenced cell. 

Cells A1 and A2 contain the values 10 and 20

A3 contains the addition of these values, 30. The formula in A3 therefore is: =A1+A2.

Cells A1 and A2 could contain different values such as 20 and 45

A3 (=A1+A2) therfore is 65. Cell A3 is effected by the variables.

Check out this website: http://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/314_spreadsheet_concepts/variables_rules/miniweb/pg2.htm

Posted: 08-12-12 14:39 by Daniel

thanks :)

Posted: 08-12-12 15:59 by Thegirlwhoknewtoomuch - Team GR