James Elliott wrote:
I use OOo 3.x runningunder Windows XP
There is a facility in OOo that allows you to insert a formula into a
table cell, e.g. in a table in a Writer document.
I tried this one:
=IF(C2>15; "Family membership fee"; "Single membership fee)
and it does not work.
In fact, even ths simplest of formulas do not work?
I would be much obliged if any of you can explain to me what this
'formula in tables' facility as all about.
Many thanks, James
When you click in a table cell, then use Table > Formula, you can use
the function button to get a menu and submenus of the allowable
functions. IF is not included, though you could get a truth value for
something like =<c2> g 15. If you did this for a whole column, for
instance (specifying the referenced cells as needed), you could then
select the column and edit it to replace the 0 and 1 values as
appropriate. (Of course, changing the value in the referenced column
would not cause reevaluation; the formulas would no longer be there.)
It's much easier to set this up in Calc, though, and there are some ways
to get the result into Writer. If you stick to the supplied functions,
or just use standard mathematical operations, formulas always seem to
work well in tables for me (using various Windows and OOo versions). One
additional thing is that any formulas themselves are lost when you Save
As to a filetype other than .odt, only the values are kept.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
