On Tuesday 31 May 2005 04:02 pm, Brent Opsahl wrote:
> I have been trying to figure out how to lock a formula to one cell.
> it is the function you use in excle that goes like this $C5* A6, and
> then when you fill the formula down it stays on C5 when you go to A7
> and so on for as long as you want to go. and in OpenOffice calc i
> can't seem to get this to work.
>
> Have a great day
>
> Brent
An answer on the mailing list that you may not have seen:
Change the formula to read =$C$5*A6
Because:
$C = Locks the formula to the third column ("C")
$5 = Locks the formula to the fifth row
oldgnome
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
