Can we have an empty cell but formula embedded in that cell.
Can we have an empty cell but formula embedded in that cell.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks