Double Quotes
 

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?

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?

Double Quotes
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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?