IF(OR(ISBLANK) Statement

Duane B

I am trying to set a colored dot to Green if the project is on time, Red if it is late and Yellow if it is not started ([Date Completed] = blank).  The Red and Green work, but I cannot get the yellow dot.  Any help would be greatly appreciated.  This is the formula as it stands.

 

=IF(OR(ISBLANK([Date Completed]1, "Yellow"), IF([Date Completed]1 - [Scheduled Date]1 <= 0, "Green", IF([Date Completed]1 - [Scheduled Date]1 > 0, "Red"))))

Lee Joramo

This should work for you. Your formula was incorrectly written around the ISBLANK function. Formatted for reading:

=IF (

    ISBLANK([Date Completed]1),

    "Yellow",

    IF (

        [Date Completed]1 - [Scheduled Date]1 <= 0,

        "Green",

        IF (

            [Date Completed]1 - [Scheduled Date]1 > 0,

                "Red"

        )

    )

)

 

and for copy and paste:

=IF ( ISBLANK([Date Completed]1), "Yellow", IF ( [Date Completed]1 - [Scheduled Date]1 <= 0, "Green",  IF ( [Date Completed]1 - [Scheduled Date]1 > 0, "Red" ) )

)

--

Lee Joramo

Data Integrations Developer - Mesa County Valley School Dist. 51

970-254-5104  x11556

Duane B

That worked!  Thanks.

Lee Joramo

This forum is not allowing me to correct the formatting of the copy and paste test.  Here it is again:

=IF(ISBLANK([Date Completed]1), "Yellow", IF([Date Completed]1 - [Scheduled Date]1 <= 0, "Green",  IF([Date Completed]1 - [Scheduled Date]1 > 0, "Red" )))