what does "" mean in excell
 

please help

what does "" mean in excell
 

Chris,

It means nothing, literally a Null value.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"chris" wrote:

please help

what does "" mean in excell
 

In the context of a formula like =IF(A1="","",A1)

It means if A1 is empty or blank then return a blank.

A1 may not necessarily be empty.

It could have a formula which evaluates to "" so the above formula would see
that as blank.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:29:09 -0700, chris
wrote:

please help

what does "" mean in excell
 

It's an empty string.

It makes the cell look blank/empty--but it's not. It contains a formula.

Lots of people (too many!!) use:

=if(a17,"Too many"," ")
with the extra space character.

But this can cause trouble in cells that check the value in that cell.

=if(b1="","looks blank","doesn't look blank")

If b1 contained " ", then this formula would return the "doesn't look blank"
string.

chris wrote:

please help

--

Dave Peterson

what does "" mean in excell
 

"chris" сообщил/сообщила в новостях следующее: ...

please help



"" also means just " but inside the double quotes: =LEFT("John ""JD"" Doe",4)