Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - How to hide formula output in Spreadsheet?
How to hide formula output in Spreadsheet?
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
mekkon
Blue Pill


Joined: Aug 29, 2006
Posts: 4

PostPosted: Sat Oct 04, 2008 10:49 am    Post subject: How to hide formula output in Spreadsheet?

Hello,
I just whipped up a basic spreadsheet with some sum totals in it and other basic formulas, and I'm wondering how I can make it hide the output in the cells if there is no input in a given row.
Sounds strange phrased like that but the idea is simple. I have columns set up for date, item, cost, etc. The last column is a running total. I've pasted the formula for the total down that column so that as I enter each amount through the month, the last column always reads the total amount spent. Great. BUT - for the hundred lines or so below it, that running total is also displayed, since those cells have that formula too. Any way to make those not show up until I actually enter values in that row?

Or does this post even make sense? I suppose I could post a screenshot if necessary... Many thanks
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Sat Oct 04, 2008 11:18 am    Post subject:

I can't check right now, but I think you want to use ISBLANK, so that in the sum column, you'd do something like =ISBLANK(input_column," ",formula), where input_column is one of the columns you use in the regular calculation and that is going to be blank in these later rows, and formula is the current formula you're using. " " is just telling Neo to display a space if the cell in the input column is blank.

Check the help for ISBLANK to make sure I've given you everything correctly from memory Wink

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Sat Oct 04, 2008 12:02 pm    Post subject:

I have a spreadsheet where I use ISBLANK, in combination with IF. Cell L33 contains the following formula:

Code:
=IF(ISBLANK(C33);"";L32+K33)


In other words, if C33 is blank, then cell L33 is blank. But if there is a number in C33, then L33 displays the sum of L32 and K33.

Lorinda
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Sat Oct 04, 2008 2:51 pm    Post subject:

Hehe, I conflated the two commands in my head Embarassed That's right, ISBLANK only returns true or false, so you need an IF command to do the rest of the work.

Thanks, Lorinda; maybe next time when I can't check first, I'll just wait and let you answer Wink

Smokey

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
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
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.