Thread
:
empty cell as a result of IF formula
View Single Post
#
4
Posted to microsoft.public.excel.misc
Jeremy BZH[_2_]
external usenet poster
Posts: 4
empty cell as a result of IF formula
i need to use this cell with the formula result ("") for another calculation
with SUM(), but this result is #VALUE!,at the same time time, i use it for a
Count() formula and it works (it doesnt count it).
can i use something else than "" that will work both with SUM and COUNT ?
"JoeU2004" wrote:
"Jeremy BZH" <Jeremy
wrote:
i need to obtain an empty cell as a result of a "IF" formula, i usually
use
=if(logical test;"";value_if_false)
but i cannot use this result in a SUM formula
Perhaps you want:
=if(condition, "", SUM(range))
Note that this does not result in an "empty cell" per se. In particular, if
that formula is in A1 and it results in "", ISBLANK(A1) will be false(!).
A formula can only result in the null string, which makes the cell
__appear__ empty or blank. You can detect truly empy (no formula or
constant) or null string by testing A1="".
Reply With Quote
Jeremy BZH[_2_]
View Public Profile
Find all posts by Jeremy BZH[_2_]