Cell display
 

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

Cell display
 

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" wrote:

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

Cell display
 

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

"dimm" wrote:

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" wrote:

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

Cell display
 

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

<Tools <Options <Calculation tab.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BF SMITH" <BF wrote in message
...
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

Cell display
 

I solved it. Thanks

"Ragdyer" wrote:

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

<Tools <Options <Calculation tab.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BF SMITH" <BF wrote in message
...
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