Paired Quote marks in Excel IF statement

[mjwskier]

In an IF statement, the "Value_if_true" line contains a pair of quote marks.
What does this mean?

 

[Rick Rothstein]

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.

 

[Pete_UK]

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