Simple Function with some tricky baggage

[Jeronimo9999]

I have a spreedsheet with three columns, one tells a document's due date, one tells the date the document was turned in, and the third tells whether or not the document was on time. by this formula =IF(C5>D5,"yes","No")

The Trick....

Some of the due date columns are marked "ASAP"

Because of this I need to manipulate the formula in the third column to say "yes" if on time, "no" if late, and "Rushed" if the due date column says ASAP.

Here is what I keep trying...

=IF(C5>D5,"yes","no",IF(D5="ASAP","Rushed"))

though it always comes out as an error.

[reggie1000]

try this,


=IF(AND(C6>D6),"yes",IF(AND(D6="ASAP"),"RUSHED","NO"))


cheers reg