Double Quotes

  • Thread starter Thread starter budlightknight
  • Start date Start date
B

budlightknight

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?
 
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.
 
We speak of double quotes for the symbol "
On a US keyboard it is found to the left of the ENTER key; you need to hold
Shift
The symbol you get without SHIFT is a singe quote ' (aka apostrophe)
best wishes
 
Back
Top