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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top