Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double Quotes | Excel Discussion (Misc queries) | |||
display double quotes in an cell | Excel Discussion (Misc queries) | |||
Save As CSV, double quotes | Excel Discussion (Misc queries) | |||
convert spreadsheet to csv with double quotes | Excel Discussion (Misc queries) | |||
How to get double quotes to show up after pasting? | Excel Worksheet Functions |