Microsoft Office excel 2007 home & stude...

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?

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

or

=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.MIKE

Ah perfect!

=IF(ISBLANK(E13),"",IF(D13>=E13,"YES","NO") )Was the chosen formula! Thank you.

Back with another parameter...to 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?

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_testtest in order you don't have to check for D19=E19.If all three of the

logical_testsfail, then the function returns thevalue_if_falsefor 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.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History