E
Easydoesit
What do the empty set of quotes mean in some of the functions and formulas
described here?
described here?
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.
J
JMB
empty string. you probably see them mostly in IF statements. Excel won't
display anything on the screen, but it is not the same as entering a zero
value because it has a text format. So you could run into problems if
dependent cells are trying to perform calculations on a cell that returns (or
could return) an empty string.
display anything on the screen, but it is not the same as entering a zero
value because it has a text format. So you could run into problems if
dependent cells are trying to perform calculations on a cell that returns (or
could return) an empty string.
B
Bob Phillips
It also is not the same as empty or blank, so if you do an ISBLANK test on
it, it fails.
it, it fails.
E
Easydoesit
What are the advantages in returning an empty string text cell versus just
leaving it blank?
leaving it blank?
J
JMB
Most of the time, I use it to serve as a conditional for an IF statement. If
you don't tell the IF statement what to return if the condition you are
testing is false, it will return FALSE (a boolean value). I use "" as it
makes the spreadsheet look cleaner. If I have a lot of dependent
calculations that may not like "" and I don't care how clean the spreadsheet
looks, I'll have the IF statement return zero.
you don't tell the IF statement what to return if the condition you are
testing is false, it will return FALSE (a boolean value). I use "" as it
makes the spreadsheet look cleaner. If I have a lot of dependent
calculations that may not like "" and I don't care how clean the spreadsheet
looks, I'll have the IF statement return zero.