How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?


B

boneyzz

When i drag down the formula from Cell A1, it goes like this, cell
A1:c1/b1, cell A2:c2/b2, cell A3: c3/b3, cell A4:c4/b4 and so on..

I would like the formula to be like this, cell A1:c1/b1, cell A2:c2/b1,
cell A3: c3/b1, cell A4: c4/b1 ..

How do i keep it constant at b1? Any form of assistance will be
appreciated. Thanks in advance!

Regards,
Matt
 
Ad

Advertisements

R

Ron Coderre

Switch from this:
A1: =C1/B1


to this:
A1: =C1/B$1
Then copy that formula down.

(The dollar sign in a reference "locks in" that part of the
reference.)

Does that help?

Regards,
Ron
 
Ad

Advertisements


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

Top