How do I omit a blank cell from a calculation??
Some clarification as to what you want to do and what your existing formula
is would probably help. Also, when you say "blank" cell, do you mean a cell
that is truly empty or one that appears to be empty, but contains an empty
string (ie "")
A few suggestions you could play with:
=A1=""
=Len(A1)0
=Isnumber(A1)
=Isblank(A1) - this function will distinguish between a truly *empty* cell
and one that contains the empty string
"marklg" wrote:
How do I discriminate between a blank cell and a zero value cell in a formula?
|