OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] - display summed cell as blank instead of zero

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
piper975
General User
General User


Joined: 19 Jan 2012
Posts: 8

PostPosted: Wed Feb 08, 2012 8:04 am    Post subject: [SOLVED] - display summed cell as blank instead of zero Reply with quote

I would like to have a cell return as blank or nothing displayed when the summed value is equal to zero, is there an easy way to do this ?

Code:

=sum(C8:C15)


this would return a value in C16 as "0" if there was no values entered into the C8 to C15 range.

Any questions please ask Smile


Last edited by piper975 on Wed Feb 08, 2012 8:59 am; edited 1 time in total
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Feb 08, 2012 8:48 am    Post subject: Reply with quote

Tools>Options>Calc>View>Display zero=OFF
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
piper975
General User
General User


Joined: 19 Jan 2012
Posts: 8

PostPosted: Wed Feb 08, 2012 8:58 am    Post subject: Reply with quote

thanks ...

Tools > Options > OpenOffice.rg Calc > View > Display > Zero values

uncheck = OFF
check = ON
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group