| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Linear Mode
