M
marklg
How do I discriminate between a blank cell and a zero value cell in a formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
It depends on what you want to accomplish with the formula.
One way to test for numeric 0:
AND(COUNT(A1),A1=0)
One way to test for numeric 0:
AND(COUNT(A1),A1=0)
J
JMB
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
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
R
Ragdyer
What's your definition of "Blank"?
Is it an unused *empty* cell,
OR
a cell that appears empty but contains a zero length text string ( "" )?
Then, what is the formula you're trying to use?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Is it an unused *empty* cell,
OR
a cell that appears empty but contains a zero length text string ( "" )?
Then, what is the formula you're trying to use?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
formula?marklg said:How do I discriminate between a blank cell and a zero value cell in a
M
marklg
Ragdyer said:What's your definition of "Blank"?
Is it an unused *empty* cell,
OR
a cell that appears empty but contains a zero length text string ( "" )?
Then, what is the formula you're trying to use?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
formula?
The cell is unused. I'm trying to solve an equation of the form ax-b where not all cells in the range of x have values and can be =0. Seems simple enough, but not to me I guess.
Thanks for answering.
marklg
D
Dave
Hi,
If your maybe blank cell is (for example) A10, then try an IF around your
formula, something like:
=IF(A10="","x is blank",YourFormula)
Regards - Dave.
If your maybe blank cell is (for example) A10, then try an IF around your
formula, something like:
=IF(A10="","x is blank",YourFormula)
Regards - Dave.