Perhpas I am an idiot, but I could not find this in the online help anywhere.
Maybe someone has conquered this problem. I want to do a fill down command,
but use a single cell as a multiplier for each line. For example, I want to
calcuate a value across a row, with a number in the final cell column of that
row. Then I want to add a calculation that will multiply the number in that
cell by a number in a single cell somewhere else on a sheet (profit margin
calculation). When I do a fill down it keeps trying to use the value in the
cell below the single cell:

=(L11*M6)
=(L12*M7)
=(L13*M8) and so on.

I just want them all to read

=(L11*M6)
=(L12*M6)
=(L13*M6)

But still be able to use the fill down as sometimes these columns get quite
large.
Thanks,

Hi,

=(L11*$M$6) and copy it down

"Bassplayer4x4" wrote:

Perhpas I am an idiot, but I could not find this in the online help anywhere.
Maybe someone has conquered this problem. I want to do a fill down command,
but use a single cell as a multiplier for each line. For example, I want to
calcuate a value across a row, with a number in the final cell column of that
row. Then I want to add a calculation that will multiply the number in that
cell by a number in a single cell somewhere else on a sheet (profit margin
calculation). When I do a fill down it keeps trying to use the value in the
cell below the single cell:

=(L11*M6)
=(L12*M7)
=(L13*M8) and so on.

I just want them all to read

=(L11*M6)
=(L12*M6)
=(L13*M6)

But still be able to use the fill down as sometimes these columns get quite
large.
Thanks,

=L11*M$6

It's the difference between relative and absolute addresses. Look it up in
Excel help

And you don't need the parentheses.
--
David Biddulph


"Bassplayer4x4" wrote in message
...
Perhpas I am an idiot, but I could not find this in the online help
anywhere.
Maybe someone has conquered this problem. I want to do a fill down
command,
but use a single cell as a multiplier for each line. For example, I want
to
calcuate a value across a row, with a number in the final cell column of
that
row. Then I want to add a calculation that will multiply the number in
that
cell by a number in a single cell somewhere else on a sheet (profit margin
calculation). When I do a fill down it keeps trying to use the value in
the
cell below the single cell:

=(L11*M6)
=(L12*M7)
=(L13*M8) and so on.

I just want them all to read

=(L11*M6)
=(L12*M6)
=(L13*M6)

But still be able to use the fill down as sometimes these columns get
quite
large.
Thanks,