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.
-- Peter Kupfer OOo user since 'OO4 http://peschtra.tripod.com/open_office/ooo_front.htm
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
