conditional cell hiding

Short answer, yes and no. You can't really hide a cell, only rows or columns, BUT, you can make it appear "invisible", that is, without anything "showing" in it.

Can you explain a little further what you're after ?

Juan Pablo G.

Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

Re: Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

OK, I'm creating a spreadsheet to compute the costs of many different offices. I'd like to use my spreadsheet for each site; however, the number of years they've been in operation changes. I'd like to set up my tables for 20 years, knowing that some offices will only have been in existence for 5 years. In this case, I would like to hide 15 years of possible calculations.
Thanks for the help!

Hiding rows and columns would work well too . . . Basically, I'm creating a template that will compute the costs of an office for its entire life. I'll be visiting ~40 sites, however, and so the length of time they've been in operation varies. In some cases, I would like to hide several years of data, even though the calculations remain in those cells for programs with longer durations.
Thanks again for the help!

Re: Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

can you just hide the rows you don’t need? If so select the rows you want to hide and go to format, rows, hide

how about ...

something like:
=IF(yourformula,yourformula,""),or if you need to do arithmetic operations on what the formulas return:
=IF(yourformula,yourformula,0) and custom format the cells as 0;-0;
thanks to mark w for the custom formatting