Show empty cell if product is zero after re-open

Discuss the spreadsheet application
Post Reply
CSmith
Posts: 3
Joined: Sat Jan 26, 2013 7:54 pm

Show empty cell if product is zero after re-open

Post by CSmith »

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
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Show empty cell if product is zero after re-open

Post by FJCC »

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.
Post Reply