Help on writing formula on planning spreadsheet

[bjd1020]

I am in the process of creating a spread sheet that will track the work of 4 of my programmers and eventually help to build a schedule. I have created a list of process areas that they go through to complete each job. I have also created a time stamp button so when they open the sheet, they can time stamp the function when its started and completed. What I would like to do is have the status column update automatically when the processes are time stamped. I have created an if formula in the status column, and it works, but only for certain status changes. Any suggestions? See attached.

When the work assigned is stamped the status changes to "In Queue" so that works
When the Work initiated is stamped it the status changes to "WIP" so that works
When the manf data delivered is stamped the status should change to "Production" that does not work
When the requestor emailed is stamped the status should change to "FFF" that does not work
When the ESIG Sent is stamped the status should change to "ESIG" that does not work
and when the closed is stamped the status should change to "complete" that does not work

[ChemistB]

You need to work your nested IF statements in Col F from last to first because for example as soon as it sees O2>N2, it'll stop at WIP

=IF(AK2>AI2,"Complete",IF(AI2>AE2,"ESIG",IF(AE2>AC2,"FFF",IF(AC2>O2,"Production",IF(O2>N2,"WIP",IF(N2>0,"In Queue",""))))))
Does that help?

[dredwolf]

Try this instead :
=IF(N2="","",IF(O2>N2,IF(AC2>O2,IF(AE2>AC2,IF(AI2>AE2,IF(AK2>AI2,"Complete","ESIG"),"FFF"),"Production"),"WIP"),"In Queue"))

EDIT-
OOPS.ChemistB beat me to it

[bjd1020]

That worked perfectly.

Thank You!!!