Thread: Double Quotes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Double Quotes

Try this...

In A1 enter the number 1.

Then enter this formula in B1:

=IF(A1=1,"x","")

Now, change the entry in A1 to anything other than the number 1.

Notice what happens to cell B1. If A1 does not contain the number 1 B1 will
appear to be blank.

--
Biff
Microsoft Excel MVP


wrote in message
...
I'm working on a nested IF statement and the instructions from the
teacher say to use 2 double quotes in the formula for a cell to appear
blank. I don't know how or where to get the double quotes. Any help?