It's sometimes useful to "name" a cell. For example let's say that you have
a cell with the US-to-
Canadian dollar conversion rate in it.
Wouldn't it be nicer to write a formula like
= 5.00 * US_TO_CAD
Rather than
= 5.00 * A3
To do this, right click the cell you want to name
Then click Edit names...
You'll see the variables editor which will allow you to assign a formula to any variable
name. In the
example below, we're telling the system "anytime you see US_TO_CAD, replace it with the value in
Sheet1, cell A3"
Click OK to close the dialog.
Then you can write a formula that uses the variable such as:
=Project!C3 * US_TO_CAD
