How do I get IF formula to give BLANK output

Microsoft Office excel 2007 home & stude...
November 3, 2010 at 05:15:20
Specs: Windows Vista
Hi I'm trying to set a column to auto fill YES / NO if criteria are met.

Using =IF(D19>=E19,"YES","NO") I have the auto YES/NO output. But when the E Column is blank its still returning a "YES" I want it to remain blank.
I've tried a Nested IF as well :
=IF(D19>=E19,"YES",IF(D19>=E19,"NO",IF(D19>E19,"/"))) with varriations on "/" final output to no avail.

The D and E columns are both dates. Is there an ELSE function I can use?

See More: How do I get IF formula to give BLANK output

Report •

November 3, 2010 at 06:42:39

=IF(E19="","",IF(D19>=E19,"YES","NO") )


=IF(ISBLANK(E19),"",IF(D19>=E19,"YES","NO") )

The first of the nest IF's checks to see if cell E19 is blank,
if it is blank, then it makes it blank, other wise do your calculations.


Report •

November 3, 2010 at 07:15:30
Ah perfect!
=IF(ISBLANK(E13),"",IF(D13>=E13,"YES","NO") )

Was the chosen formula! Thank you.

Report •

November 4, 2010 at 09:44:48
Back with another auto fill "Perfect" if the dates match. Tried a few variations to no avail.

=IF(ISBLANK(E19),"",IF(D19>=E19,"YES","NO"),IF(D19=E19,"Perfect") )

=IF(ISBLANK(E13),"",OR((D13>=E13),"YES,"NO",(D13=E13),"Perfect") )

=IF(OR(ISBLANK(E13),"",D13>=E13,"YES,"NO",OR(D13=E13),"Perfect") )

Any advice?

Report •

Related Solutions

November 4, 2010 at 10:14:55
Before we even deal with the syntax of formula, there's a problem with your criteria.

Based on the formulas that you have tried, you appear to be asking for these results:

IF D19<E19, "NO"
IF D19>E19, "YES"
IF D19=E19, "YES"
IF D19=E19, "Perfect"

You are asking for both a YES and a Perfect when D19=E19, which I'm pretty sure you don't really want.

So assuming, you really want this:

IF D19<E19, "NO"
IF D19>E19, "YES"
IF D19=E19, "Perfect"

Try this:

=IF(ISBLANK(E19), "", IF(D19<E19,"NO", IF(D19>E19,"YES", "Perfect")))

Since the IF function performs each logical_test test in order you don't have to check for D19=E19.

If all three of the logical_tests fail, then the function returns the value_if_false for the last IF.

If E19 isn't blank and isn't < D19 and isn't > D19, then the function returns "Perfect" - not because D19 = E19, but because all of the other condtions were FALSE.

Report •

Ask Question