Help with If ISBLANK or statement

01/25/18 Edited 12/09/19

I'd like a column to populate "late" based on whether another column has a date in it or is blank.  Does anyone have any experience with nesting this type of formula?

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    =IF(OR(ISBLANK([column name]24), ISDate([Column24])), "Late", "")

    Try this... you need to replace your column name you're checking for the date in and set it up for the right row number. This for row 24. 

     

Sign In or Register to comment.