"" (double quotes with nothing between)

  • Thread starter Thread starter seymourgomez
  • Start date Start date
S

seymourgomez

I see this in formulas that reference a cell. I can't figure out what it
means.
 
For example:
=IF(A1>400,"Large","") would display the word Large if A1 were greater than
400, but the cell would look empty if A1 were not greater than 400.
if you used this:
=IF(A1>400,"Large")
then you might see the word FALSE in the cell.
 
You must log in or register to reply here.

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

How to do double quotes in "cell language"? 4
Double Quotes 5
Auto fill values with a blank row formatting between entries 7
SUMPRODUCT Problem 2
Logical IF return a cell reference 2
Column headings display as a numbers 7
AutoFill double click does not work in Excel 2007 3
Count based on cell value between two numbers 4

Back
Top