On Tue, Aug 30, 2011 at 5:52 AM, John Jason Jordan <johnjas...@gmail.com>wrote:
> On Mon, 29 Aug 2011 18:28:14 +0100 > openoffice.mbou...@spamgourmet.com dijo: > > >In writer, it appears the cell references need to be surrounded in > >angle brackets, i.e. for E use =(<D1>-<C1>)*B1 and for F use > >=<B1>*<D1>. The sum() function is not needed in this case - it is > >useful if you have a range of cells whose values you want to add, e.g. > >=sum(<A1:A5>). > > The brackets! That was the secret that I was missing. > > Thanks! > > (And yes, there is a reason I am doing the table in a Writer document > and not in Calc.) > There is probably a reason for using a writer table for these calculations in writer, but you can insert a calc table into a writer document. This will then enable all the functions of calc. Just a thought. /paul > -- > ----------------------------------------------------------------- > To unsubscribe send email to users-unsubscr...@openoffice.org > For additional commands send email to sy...@openoffice.org > with Subject: help > -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help