How to keep a cell empty at the same time formula embedded?

[vic_dic]

Can we have an empty cell but formula embedded in that cell.

[CLR]

A cell cannot be both "empty" and contain something...........you can
however, put a formula there that will display a blank cell according to the
conditions of it's calculations...........

=(IF(A1>5,A1,"")......will display a blank cell if A1 is 5 or less

Vaya con Dios,
Chuck, CABGx3




"vic_dic" <[email protected]> wrote in message
news:[email protected]...
> Can we have an empty cell but formula embedded in that cell.

[JE McGimpsey]

What are you really trying to do?

A cell can contain either an entered value or a formula, but not both.
However, there are ways using VBA to work around that.

In article <[email protected]>,
"vic_dic" <[email protected]> wrote:

> Can we have an empty cell but formula embedded in that cell.