Re: [libreoffice-users] Use of variables in a cell

At 13:36 20/07/2016 -0700, John R. Sowden wrote: Thank you very much. No probs! I've got it now. I thought of explaining it all the first time around. Not sure why I didn't. Actually it is easier than I thought (often the case). Indeed so. Brian Barker -- To unsubscribe e-mail to:

Re: [libreoffice-users] Use of variables in a cell

Thank you very much. I've got it now. I thought that a variable was placed in the range, and I had to assign a value to that variable. Actually is is easier than I thought (often the case). Hope others have seen your explanation and have benefited also. John On 07/20/2016 11:08 AM, Brian

Re: [libreoffice-users] Use of variables in a cell

At 10:23 20/07/2016 -0700, John R. Sowden wrote: I think you just introduced another set of questions. I don't think so ... Is the "&" used for macro substitution? Er, nope: it's the concatenation operator. I assume the lowercase n is a shorthand way of defining the variable type

Re: [libreoffice-users] Use of variables in a cell

I think you just introduced another set of questions. Is the "&" used for macro substitution? If so, how does that fit in? I assume the lowercase n is a shorthand way of defining the variable type (n=number, s=string, etc.), and not part of the formula? I went to Help with indirect(), not

Re: [libreoffice-users] Use of variables in a cell

At 08:50 20/07/2016 -0700, John R. Sowden wrote: If I have a cell with following formula, can I replace a cell coordinate, such as the 52 below, with a variable that I can assign at the top of my spreadsheet? =sum(a1:a52) Yes: =SUM(INDIRECT("A1:A")) I trust this helps. Brian Barker -- To

[libreoffice-users] Use of variables in a cell

If I have a cell with following formula, can I replace a cell coordinate, such as the 52 below, with a variable that I can assign at the top of my spreadsheet? =sum(a1:a52) Thanks, John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?