Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What do I use to reference the same cell in multiple formulas
I am trying to set up a formula where I will need to use for expample D3 in
all formulas, is there a way I can keep that in each formula without having to enter it each time when I copy the formulas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What do I use to reference the same cell in multiple formulas
Use
$D$3 -- Regards, Peo Sjoblom "Tammy" wrote in message ... I am trying to set up a formula where I will need to use for expample D3 in all formulas, is there a way I can keep that in each formula without having to enter it each time when I copy the formulas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What do I use to reference the same cell in multiple formulas
Reference it in absolute terms: $D$3
that way it won't change as you fill/copy the formula to other cells. You may also want to look into using Named Ranges - see Excel Help on the topic. That allows you to give a name to a cell and use that name in formulas without having to worry where the cell is. Lets say that your formula contains the sales tax rate in your area. You could name cell D3 SalesTax and then in your formula you could use SalesTax instead of $D$3. "Tammy" wrote: I am trying to set up a formula where I will need to use for expample D3 in all formulas, is there a way I can keep that in each formula without having to enter it each time when I copy the formulas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the reference type of multiple formulas | Excel Discussion (Misc queries) | |||
change the reference type of multiple formulas | Excel Discussion (Misc queries) | |||
Update reference in multiple formulas | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
transferring formulas with absolute reference to multiple tabs | Excel Discussion (Misc queries) |