Using a single cell in multiple formulas

G

Guest

I am trying to calculate a formula for a range of cells using one particular
cell as a basis for the others.
EX: Need a calculation in cells B13:B16, using A13:16 as a variable for
each row and A2 & A3 for each formula as another variable. Whenever I copy
and paste the formula into multiple rows, it bring down the A2 & A3 down to
the next row. I need these to be the same for every row.
 

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

Formulas in a cell 2
Creating a formula relating to several cells 2
Locking a cell reference in a formula 1
Multiple Numbers in a cell 3
multiple IF formulas 8
formulas 5
using a cell's reference to return a value. 3
Like SUMIFS, but for multiplication??? 3

Top