Double Quotes

[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?

 

[T. Valko]

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.

 

[Bernard Liengme]

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