Hello,

I have a huge spreadsheet that I am trying to gather some data in. I have
successfully entered a couple of nested if statements, but am having trouble
with one particular one. The table looks like this:
Column I Column J Column P Column Q
"Due MO's Completed Released On
Date" "Release Date" on Time Time Status

1/5/08 1/6/09 LATE FALSE
7/17/06 5/17/06 LATE ON TIME

The formula I am using is: =IF(AND(P51="LATE",J51<I51),"ON
TIME",IF(AND(P51="C",J51=I51),"LATE"))

As you can see, it is working in the second row, but I keep getting a false
in the last cell on the first row. I want it to return a "LATE". Can
someone please tell me what I have done wrong? Thanks in advance for any
assistance you can give me.