G. Roderick Singleton wrote:
On Sat, 2005-02-05 at 08:00 -0700, Doug Thompson wrote:
G. Roderick Singleton wrote:
On Fri, 2005-02-04 at 23:22 -0600, Peter Kupfer wrote:
javier wrote:
I'm stuck with quite a stupid question.
I'm working in writer with a table with calculations. I wan't a cell to
display a value only if it's positive and 0 when the value is negative.
In calc, this formula work all right:
=IF(A1>A2;A1-A2;0)
but in writer
=IF(<A1>><A2>;<A1>-<A2>;0)
doesn't work. It always return the failed result (0). And the reverse
condition <A1><<A2> can't be checked (it returns an error, probably it
sees the "<" sign as the start of a cell reference).
Any idea of a workaround?
Should I file an Issue?.
Try =IF(<A1>g<A2>;<A1>-<A2>;0)
The g is the writer table command for greater than. This was listed in
the help. You may want to check there in the future. Search for "greater
table" than click *formula*. This will also get you a list of all of the
Writer table functions.
Also, if you press *F2* while in a table cell, you will get the formula
bar.
However, I don't see any reference in the help for the IF statement.
In preparing the user guide, I din not find any reference to IF either
when dealing with tables or fields. The IF is implied by braketing. Sort
of like using brackets in /bin/sh to show the use of test().
As most current and potential users of OOo are not programmers, the
"implied IF" needs to be carefully explained in the Help files and the
Users Guide.
My $0.02,
Doug
Please write it up and attach it to
http://www.openoffice.org/issues/show_bug.cgi?id=29679 I will integrate
it as soon as I get your contribution.
The clock just started. ;-)
DT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
