A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

" "



 
 
Thread Tools Display Modes
  #1  
Old June 19th, 2005, 06:14 AM
Easydoesit
external usenet poster
 
Posts: n/a
Default " "

What do the empty set of quotes mean in some of the functions and formulas
described here?


  #2  
Old June 19th, 2005, 06:35 AM
JMB
external usenet poster
 
Posts: n/a
Default

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.


"Easydoesit" wrote:

What do the empty set of quotes mean in some of the functions and formulas
described here?



  #3  
Old June 19th, 2005, 09:47 AM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

It also is not the same as empty or blank, so if you do an ISBLANK test on
it, it fails.

--
HTH

Bob Phillips

"JMB" wrote in message
...
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.


"Easydoesit" wrote:

What do the empty set of quotes mean in some of the functions and

formulas
described here?





  #4  
Old June 19th, 2005, 10:57 PM
Easydoesit
external usenet poster
 
Posts: n/a
Default

What are the advantages in returning an empty string text cell versus just
leaving it blank?

"JMB" wrote in message
...
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.


"Easydoesit" wrote:

What do the empty set of quotes mean in some of the functions and
formulas
described here?





  #5  
Old June 19th, 2005, 11:15 PM
JMB
external usenet poster
 
Posts: n/a
Default

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.



"Easydoesit" wrote:

What are the advantages in returning an empty string text cell versus just
leaving it blank?

"JMB" wrote in message
...
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.


"Easydoesit" wrote:

What do the empty set of quotes mean in some of the functions and
formulas
described here?






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.