use the number in one cell for different formulas

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

Guest

when I copy and paste the formula I want into adjacent cells, it does not
retain the particular cell I want to use. I had to input each formula
manually. How do I keep using the one cell I need as part of the formula, as
the divisor? i.e., sum=(a1)/(f12), keeping a1 as the constant divisor, no
matter what other cell I use (b7) for example???
 
Use the "$" signs to fix the cell reference

Eg if you have it in G12 as: =A1/$F$12, then when you copy G12 and paste it
elsewhere, the divisor (cell F12) will not change
 

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

Back
Top