Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What does double quotation in Microsoft Excel means

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-01-2012
Member
 
Join Date: Jan 2012
Posts: 29
What does double quotation in Microsoft Excel means

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.

Reply With Quote
  #2  
Old 27-01-2012
Member
 
Join Date: Jul 2010
Posts: 30
Re: What does double quotation in Microsoft Excel means

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.
Reply With Quote
  #3  
Old 27-01-2012
Member
 
Join Date: Apr 2010
Posts: 77
Re: What does double quotation in Microsoft Excel means

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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What does double quotation in Microsoft Excel means"
Thread Thread Starter Forum Replies Last Post
Excel add a quotation mark everytime when I paste some text The Salt MS Office Support 4 21-02-2012 06:03 PM
How to print multiple double sided sheets from Microsoft Excel Holly Dayin MS Office Support 5 17-02-2012 02:01 PM
What does denormalized data in Excel means SirName MS Office Support 2 15-02-2012 05:49 PM
How to enter source by double clicking in Excel PuffDuff MS Office Support 2 09-02-2012 07:39 PM
What does ' + ' plus sign in front of a cell means in Excel Kungfu Pandey Windows Software 1 06-01-2012 06:31 PM


All times are GMT +5.5. The time now is 04:51 AM.