What does double quotation in Microsoft Excel means

[TheMirza]

I always come across the usage of a double quotation mark but don't really know what does it mean. If the double quotes encloses a word, then the word will be displayed. What if it is just opened and closed quotes.

[Atsushi]

Then nothing will be displayed. It's one way to get rid of "#value" error messages. I used to get the same and used in a formula, double quotes means nothing. In your example formula. If A3 is nothing(null, blank) then display the contents of A2 else display the contents of A3. If A2 and A3 are blank, then nothing will be displayed.

[Jona-thon]

I don't think that will fly, "" can be used as a result (kinda) but not as a term. i.e. If this formula "=If(A3=0,"",A3)" was in cell A2 , then a "0" was entered in cell A3, Cell A2 would be blank (not a "0"). Any other values would be placed in cell A2 normally. If you are looking for blank values to do something than look into ISEMPTY function.