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(A15,A1,"")......will display a blank cell if A1 is 5 or less
Vaya con Dios,
Chuck, CABGx3
"vic_dic" wrote in message
...
Can we have an empty cell but formula embedded in that cell.
|