Using variable names for cells

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
I seem to remember a technique where I could assign a variable name to
the contents of a cell so that whenever I wanted to use the contents,
all I had to do was call up the variable name. Unfortunately I cannot
find the way to set up the process. Any suggestsions or ideas would be
appreciated. Thanks and a Happy New Year.
 
You can name a cell, then use that name in a formula. For example:

In cell C2, type: .07
Select cell C2
Click in the Name Box, to the left of the formula bar
Type: GST
Press the Enter key, to complete the naming

In cell C5, type: 100
In cell C6, type: =C5*GST
Press the Enter key, to see the result.
 
Thanks very much all.

Debra said:
You can name a cell, then use that name in a formula. For example:

In cell C2, type: .07
Select cell C2
Click in the Name Box, to the left of the formula bar
Type: GST
Press the Enter key, to complete the naming

In cell C5, type: 100
In cell C6, type: =C5*GST
Press the Enter key, to see the result.
Click to expand...
 
Back
Top