what does "" mean in excell

  • Thread starter Thread starter chris
  • Start date Start date
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
 
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(a1>7,"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.
 

Ask a Question

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.

Ask a Question

Similar Threads

What does { } mean in excel formulas? 4
What is meaning of $ in excel 2
What does "" mean in Excel? 2
Excel What does E mean in excel numbers? 1
What Does It Mean To Be British? 3
what this is this mean in excel (1.66E06) 1
What does =B11*$C$4 mean? 2
what does mean excel? 1

Back
Top