On 11/01/2009 16:55, Gene Young wrote:
Harold Fuchs wrote:
On 11/01/2009 10:01, Harold Fuchs wrote:
On 11/01/2009 02:33, Stan Labinsky Jr. wrote:
Hello all;
Using Writer 3.0, how can I suppress the display of a zero value in
a cell containing the product (or sum) of a group of other cells?
The cell in question is formatted "Number", two decimal places
(-1234.12).
I've searched the Help file and your site... if the answer's there,
I missed it. I even looked at the "Invoice" templates, they too
appear to suffer from this issue.
My old Corel W.P. of Win95 vintage supports this behavior using the
following statement, +IF(ISVALUE(I21),J21*I21,"") but Writer
doesn't like it.
Having an invoice displaying columns of "0.00"s makes the document
look a bit unprofessional.
Thanks,
Stan
A workaround is to use the Find and Replace menu to change all
occurrences of "0.00" to " " (4 spaces) or to something like
"N/A". Not elegant but it does work.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
Sorry to reply to my own post but ...
Better: In the number formatting pane choose User Defined and enter
[<>0]#.##;[=0]" " into the Format Code box. This is conditional
formatting. It's in two parts separated by semi-colon. The first part
says "#.## if the number is not zero. The second part says " " (4
spaces) if the number is zero. For more details read up on
Conditional Formatting in the Help.
I use the statement {=IF((A1+B1);(A1+B1);"")} (do not enter the curly
braces in the cell) You can substitute other equations for A1+B1. The
result of this IF, THEN, ELSE statement is that if the equation is
true, ie; has a value, that value is entered into the cell. If it is
not true, ie; returns a null value, nothing is displayed in the cell.
Hope that helps your application.
Gene Y.
Ermm. Does this work in a table in *Writer*?
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
