Cell display

B

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
 
D

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,"")
 
B

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.
 
R

Ragdyer

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

<Tools> <Options> <Calculation> tab.
 
Top