Fill Down command Question

[Bassplayer4x4]

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,

 

[Eduardo]

Hi,

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

 

[David Biddulph]

=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.