Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Evaluating the value of a cell to "Blank" or "Empty"
0 views
Skip to first unread message
Hugo
May 13, 2009, 5:17:03 PM5/13/09
to
In several ocassions I try to enter a formula that could evaluate as blank or
empty value, so that I can use another formula using the empty value of that
cell.
empty value, so that I can use another formula using the empty value of that
cell.
For example:
Suppose C1: =Iff(B1=0, Evaluete empty, A1/B1)
C1 could be used as "Blank cell" for other formula purposes.
I have used "" and 0 value but 0 is not a valid value for 0 division and ""
will generate errors if the cell is used in other calculus.
0 new messages