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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
