What do I use to reference the same cell in multiple formulas

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

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
 
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.
 
Back
Top