Define a variable problem

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Can anyway advise me on how to define a variable in Excel. I did basic
at school as a kid and I wanted to define a variable and name it at
the beginning of the spreadsheet and then use the formulas to alter
the variable as we move through the sheets. I'm modeling financial
spreadsheets, so I might want to add 100 to the variable sales at time
t+1 or something. Can anyone help or suggest how I might get started.

Many thanks in advance

Alex
 
You could name a cell, and enter the variable in that cell. For example:

Select cell A1
Click in the Name Box, to the left of the formula bar.
Type a name for the range, e.g. t
Press the Enter key

Select another cell, and enter a formula that includes the variable
name, e.g. =B1+t

As you change the value in cell A1, the formula result will change.
 
Back
Top