Paired Quote marks in Excel IF statement
 

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

Paired Quote marks in Excel IF statement
 

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.

--
Rick (MVP - Excel)


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

Paired Quote marks in Excel IF statement
 

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

On Aug 28, 9:07*pm, mjwskier
wrote:
In an IF statement, the "Value_if_true" line contains a pair of quote marks. *
What does this mean? *