Nested IF function - Ignore Blank Cells

brandon.elmer

I'm trying to count the number of late tasks in a project plan.  The formula I'm using works as long as a row isn't blank.   =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, "").  If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1.  How do I write the formula to not include blank rows?

Mike Wilday

Will you ever have a blank finish? If not, then try this: 

=IF(isblank(Finish15),"", IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""))

brandon.elmer

That worked.  Thanks Mike!

Mike Wilday

Thanks! Glad I could help!