Re: [libreoffice-users] Re: libre office calc spreadsheet function question

On 11/20/2012 10:16 AM, eddie arni wrote:
> I figured out how to convert the values in each of the cells at the same
> time, using the "paste special" function.
>
> Another question relating to the last post:
>
> Why use =C7*$A$4 rather than =C7*A4?
If you are copying and pasting or using fill down the references 
increment according to the new location. If you need to reference the 
same cell you must use $A$1 to tell Calc (or any spreadsheet) that this 
cell reference does not change when pasting or filling down.

For a column of entries to be multiplied by a constant I have two 
choices. I can enter the constant into each formula or use an absolute 
reference to the cell where the constant's value is entered. The latter 
is generally a better technique because any time you need to change the 
value you only need to make one entry and all the calculations are 
automatically updated.
> --
> View this message in context: 
> http://nabble.documentfoundation.org/libre-office-calc-spreadsheet-function-question-tp4019527p4019799.html
> Sent from the Users mailing list archive at Nabble.com.


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted