Hide function/command

The obvious solution is just to wrap your existing formula in an IF thus:

IF(condition,"",existing foumula)

alternatively if you dont want to alter your existing formula you could try using the conditional formatting to set the font colour and the cell background colour to be the same.

If you want the cell to be treated as if it were truely empty (allowing text from adjacent cells to over-write it for example) at some times but have a value at other times, I can't think of a way using the "standard" excel functions, but there might be a way using VBA...

I'm not familiar with VBA.

Mark

I reworded my question, maybe it was a bit unclear before.

Let's say you want to leave B1 blank if A1 is blank. An if formula would look like this (enterred in B1):

=IF(A1="","",A1+10)

That formula reads: If A1 is blank, then leave B1 blank, otherwise, in B1 enter A1+10 (I just made up that formula).