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.