Posted: 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
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 _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
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