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.

Sorry to bother who ever. I found my error. Thanks again. I have gotten a
lot of information just reading other people's posts and the replies back to
them.

"Valerie" wrote:

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.

Just in case:

The third argument of the second IF is empty, so Excel uses FALSE. You can
think of your formula like this:

=IF(AND(D5="LATE",C5<B5),"ON TIME",IF(AND(D5="C",C5=B5),"LATE",FALSE))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Valerie" wrote:

Sorry to bother who ever. I found my error. Thanks again. I have gotten a
lot of information just reading other people's posts and the replies back to
them.

"Valerie" wrote:

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.