M mjwskier Aug 28, 2009 #1 In an IF statement, the "Value_if_true" line contains a pair of quote marks. What does this mean?
R Rick Rothstein Aug 28, 2009 #2 It is the "empty string"... text with no characters in it. In the example formula you are alluding to, the formula put "nothing" in the cell if the condition is true.
It is the "empty string"... text with no characters in it. In the example formula you are alluding to, the formula put "nothing" in the cell if the condition is true.
P Pete_UK Aug 28, 2009 #3 If you mean something like this: =IF(A1<=0,"",A1) it means return an empty string of text, which effectively makes the cell look blank. It is not empty, though, as it contains the formula !! Hope this helps. Pete
If you mean something like this: =IF(A1<=0,"",A1) it means return an empty string of text, which effectively makes the cell look blank. It is not empty, though, as it contains the formula !! Hope this helps. Pete
