Default values when formula returns null

ravinkhanted · Power User Joined: 14 Aug 2009 Posts: 52

I have two column E and F in calc. say I am multiplying these two columns and putting it into G column. Now if I have some values then I get correct values in cells of G column. When I the cells in E and F column are empty/blank then in G column I get '0' as output. I dont want '0' instead i want cell to remain empty/blank. One way is applying "if" formula. Do I have better options?

Same happens when I link the data between the cells. when cells are empty/blank I get '0' as the value in the linked cell.

Robert Tucker · Posted: Thu Dec 31, 2009 5:03 am Post subject:

http://www.oooforum.org/forum/viewtopic.phtml?t=58246
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)