# 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

#1 November 3, 2010 at 06:42:39
 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.MIKEhttp://www.skeptic.com/

Report •

#2
November 3, 2010 at 07:15:30
 Ah perfect! =IF(ISBLANK(E13),"",IF(D13>=E13,"YES","NO") )Was the chosen formula! Thank you.

Report •

#3
November 4, 2010 at 09:44:48
 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?

Report •

Related Solutions

#4 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 D19E19, "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 D19E19, "YES"IF D19=E19, "Perfect"Try this:=IF(ISBLANK(E19), "", IF(D19E19,"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 • 