Help copying cell formula to other cells

[tyshanklin]

Hi all,

This may be a simple fix, but I cannot figure out how to accomplish it. I need to multiply two cells, and put the value in a third cell - sounds simple enough, but when as I need this expression to run across 30 cells, the formula gets messed up.

Here's the breackdown:

- Tab "Job" Column B has the number of hours needed to complete a job.
- Tab "Financial" B4 has the cost per hour.
- Tab "Job" Column L needs to multiply the number of hours in the corresponding cell by the cost per hour (i.e. L2 needs to multiply B2 with FINANCIAL!B4, L3 needs to multiply B3 with FINANCIAL!B4, etc).

The formula I used was =B2*FINANCIAL!B4, but when I grab the square in the bottom right of the cell of L2 and drag it down, it continually adds one to B4 (changing it to FINANCIAL!B5, B6, B7, B8 and so on). Any ideas on what formula I should be using?

Thanks

 

[Trebor76]

Hi tyshanklin,

Sounds like you need to anchor (lock) cell B4 i.e.

=B2*FINANCIAL!$B$4

Hope that helps,

Robert

 

[tyshanklin]

That was it! Thank you very much!

 

[Trebor76]

You're welcome