Show empty cell if product is zero after re-open
Show empty cell if product is zero after re-open
I have a cell that is the product of two other cells. If that product is zero, I want the cell to show blank. It currently works with either of the following two formulas is in the product cell: "=IF(C1<>0,C1*D1,{})" as well as "=IF(C20>0,C20*D20,{})". The problem is that when I save and close the spreadsheet. When I open it back up, all the the previously blank product cells show up as zeros. Can I get the blankness to hold through close/open cycles?
OpenOffice 3.4.1 on Windows XP
Re: Show empty cell if product is zero after re-open
Try returning an empty string when you want the cell to look empty.
Code: Select all
=IF(C20>0;C20*D20;"")
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.