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
 
BTW. You don't need SUM, and A1 is the dividend rather than the divisor
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Formula Constant 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Simplifying array formula which evaluates as error. 5
Spurious Formula Omits Adjacent Cells 2
Multiple Criteria, One Answer 1
update formula in column when another cell formula is changed 1
Excel How to add numbers in same cell? 2

Back
Top