Same Value In Multiple Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Its been a while since I've used Excel and can't remember how you keep a
value constant in a part of a formula while changing another part of the
formula? Example: =SUM(d2/d9) d9 will stay constant, but the d2 value will
change as the formula is pasted into other cells.
 
Take a look at "The difference between relative and absolute references"
in XL Help.

=SUM(D2/$D$9)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing a range of cells based on criteria in another range 2
drag a formula downa column keeping one value the same? 2
Problem with pasting value of a sum 3
Keeping one part of a formula same, but change other cell ref? 3
Text to values 4
add new value with previous in same cell 2
excel sum function 2
syntax for "IF" commend to check for multiple empty cells bf comma 4

Back
Top