Paired Quote marks in Excel IF statement

  • Thread starter Thread starter mjwskier
  • Start date Start date
M

mjwskier

In an IF statement, the "Value_if_true" line contains a pair of quote marks.
What does this mean?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Logical IF statements 3
Multiples of 4 in an IF statement 6
Windows 10 Bluetooth Problems 2
Logical Function excel 2003 3
help with Conditional formatting pairs of cells 1
Excel How to find the most common pairs and triplets numbers? 5
Forecast IF Error Formula 2

Back
Top