Thread: empty cell as a result of IF formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default empty cell as a result of IF formula
"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 QuoteReply With Quote