| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to hide a vaue
I am trying to hide a value of 351 in a cell until the 351 is used in a
calculation. How do I do this. Example: b3 is 351 I would like to subtract b2 which is 345 and show the sum of 6 in b3. Until I fill b2 with a value, b3 is showing 351. I want to hide the 351 until the value is calculated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide a vaue
In B3 enter =IF(B2="","",351-B2)
Gord Dibben MS Excel MVP On Sat, 20 Feb 2010 07:45:01 -0800, Bill B wrote: I am trying to hide a value of 351 in a cell until the 351 is used in a calculation. How do I do this. Example: b3 is 351 I would like to subtract b2 which is 345 and show the sum of 6 in b3. Until I fill b2 with a value, b3 is showing 351. I want to hide the 351 until the value is calculated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
| hide code does not hide | Excel Discussion (Misc queries) | |||
| Hide Unhide Hide again | New Users to Excel | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
![Bill B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
