Spreadsheet Help?

Question

Hey is there any command when using a spreadsheet to hide a cells contents or display zero unless a number is put into a different cell
(I'm using OpenOffice but what works for excel seems to work for both)
Thanks

Answer 1

There is two ways to do this.

1) color the font of the content the same as the background - effectively making it invisible. However, this isn't conditional on cell contents.

2) put a conditional in the cell - in other words say if you want the cell you are in to be blank, unless C5 is > 32.2 then you want the contents of c7 in it, then place this in your cell:

=if(c5>32.2, c7, "")

this does the same thing, but put's a zero in instead of a space

=if(c5>32.2, c7, 0 )

Answer 2

In excel, its in the TOOLS and then OPTIONS area. Under the GENERAL tab there is a check box to choose whether or not to display zero values. I am not sure if the same applies in Open Office but you could probably do something inside of the cell properties also by right clicking on the cell and then choosing the appropriate menu item.

Answer 3

Create a formula in the "check" cell (assume this is B4) which references the "input" cell (assume this is A1). The formula in B4 is: =IF(isblank(A1),0,"")
This assumes that OpenOffice can handle the functions IF and ISBLANK.

The result is a 0 in cell B4 when A1 is empty and a result of "empty" (this is created by the double quote near the end of the formula) in cell B4 when A1 has anything in it.

Answer 4

u have to come up w/ some kind of formula..

=IF(E72=0," - ", E72)

u know something like that... this is a simplified version, means the cell is equal to E72, but IF E72 = 0, then a hyphen will take place. i think u can put empty space in a " ", or a zero "0". u might have to tweak it a bit! good luck.