On Fri, 4 Feb 2005, 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)
I don't know if this will help with doing it in Writer, but you can achieve this without an IF statement:
=MAX(A1-A2,0)
will deliver 0 if A1-A2 is less than zero.
You can do that in writer or in Calc? That function returns an error in my writer table. :(
--
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]
