If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|