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