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(). -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
