Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
defining a name in a cell?
What's the purpose of defining a name in a cell? How is it used?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
defining a name in a cell?
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) "mp@ea" wrote in message ... What's the purpose of defining a name in a cell? How is it used? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
defining a name in a cell?
a slight typo here ..
.. =Price*(1_Tax_Rate) gives the price including tax think it was meant as: =Price*(1+Tax_Rate) gives the price including tax -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
defining a name in a cell?
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 "mp@ea" wrote: What's the purpose of defining a name in a cell? How is it used? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining cell with only through 1 - 32 | New Users to Excel | |||
Defining a range using a cell reference | Excel Worksheet Functions | |||
Defining Cell namse after they are used in a function | Excel Worksheet Functions | |||
Defining a Cell for Save as file name | Excel Discussion (Misc queries) | |||
Defining a cell to name file | Excel Discussion (Misc queries) |