G
Guest
What's the purpose of defining a name in a cell? How is it used?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
You can reference that name in an other cell.
For instance, give a cell a name of Tax_Rate, another a name of Price, and
in another cell add a formula of =Price*(1_Tax_Rate) gives the price
including tax, and as you can see, it is very understandable.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
For instance, give a cell a name of Tax_Rate, another a name of Price, and
in another cell add a formula of =Price*(1_Tax_Rate) gives the price
including tax, and as you can see, it is very understandable.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
G
Guest
a slight typo here ..
think it was meant as:
=Price*(1+Tax_Rate) gives the price including tax
---
.. =Price*(1_Tax_Rate) gives the price including tax
think it was meant as:
=Price*(1+Tax_Rate) gives the price including tax
---
G
Guest
Hi,
You are creating a name to represent a formula or a constant.
To create a named definition
1. On the Insert menu, point to Name, and then click Define.
2. In the Names in workbook box, enter the name for the formula.
3. In the Refers to box, type = (equal sign), followed by the formula or the
constant (constant: A value that is not calculated and, therefore, does not
change. For example, the number 210, and the text "Quarterly Earnings" are
constants. An expression, or a value resulting from an expression, is not a
constant.) value.
Challa Prabhu
You are creating a name to represent a formula or a constant.
To create a named definition
1. On the Insert menu, point to Name, and then click Define.
2. In the Names in workbook box, enter the name for the formula.
3. In the Refers to box, type = (equal sign), followed by the formula or the
constant (constant: A value that is not calculated and, therefore, does not
change. For example, the number 210, and the text "Quarterly Earnings" are
constants. An expression, or a value resulting from an expression, is not a
constant.) value.
Challa Prabhu