I find OFFSET() quite useful whenever I build a table with a running
balance (for instance where the balance in X10 = X9+W10). Without the
OFFSET() function, if I needed to insert a row between rows 9 & 10, the
new row would not be included in the running balance unless I edited the
formula. But if the original X10's formula is "=OFFSET(X10,-1,0)+W10"
then the new row is automatically included in the running balance.
-- Tim
===========================
On 4/26/2015 9:15 AM, [email protected] wrote:
Correction. I ran across an old message from Mr Barker that suggested using the
OFFSET() function for something.
--
To unsubscribe e-mail to: [email protected]
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
