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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
