Cell display

[BF SMITH]

I am creating a bond amortization spreadsheet and have the cells hidden ("")
for items with zero value. Works great. Problem is getting the cells visible
again when I increase the payment periods. If I "fill down" or "F2" each
cell, the value is there. I just need to know how to make the values visible
when the prof changes the terms.
Thanks

 

[dimm]

Are you using a function to hide the cell somehow...Im not entirely sure what
your asking...do you have something like this?

IF(A1 = 0,"")

 

[BF SMITH]

=IF(A32<=($B$4*$B$5),A31+1,"")
This is the formula I am using. If I change the logic test so the next
number should be displayed because the answer is included, the cell is not
being displayed. The formula above is the exact cell I am speaking of.

 

[Ragdyer]

Sounds like perhaps your calc mode may be set to "Manual".

<Tools> <Options> <Calculation> tab.

 

[BF SMITH]

I solved it. Thanks

Sounds like perhaps your calc mode may be set to "Manual".

<Tools> <Options> <Calculation> tab.