Nest If Statements Dependent on Multiple Cells

Could someone give me the right formula for this? I cant seem to make nested IF statements work right and my experience with formulas is minimal. (Coding nonexistent)

I have 4 columns in which dates are entered. I have a fifth column for "Status".

SO I would like a formula that says:
If A1 has a value (date) then E1="Requested".
But if B1 has a value then ignore A1 statement and E1="Accepted".
But if C1 has a value then ignore A1 & B1 statements and E1="Rejected".
But if D1 has a value then ignore A1, B1 & C1 statements and E1="Completed".
And if no value in A1:D1 then E1=(blank cell)

(A1) Requested
(B1) Accepted
(C1) Rejected
(D1) Completed
(E1) Status

The columns in the attached spreadsheet to correspond with the above are K,L,M,N (A-D) and J (E)

Well, you can't have a drop-down list/data validation in column J AND a formula... one or the other. If you want a nested IF formula, you could try this:

=IF(COUNT(K3:N3)=0,"",IF(N3<>"","Completed",IF(M3<>"","Rejected",IF(L3<>"","Accepted","Requested"))))

- Moo

Another way to do it ('cuz this is fun for me):

=IF(COUNT(K3:N3)=0,"",LOOKUP(MATCH(9.99^99,K3:N3),{1,2,3,4},{"Requested","Accepted","Rejected","Completed"}))

Your file doesnt exactly match your description, but try this...

=if(D1<>"","Completed",if(C1<>"","Rejected",if(B1<>"","Accepted",if(A1<>"","Requested",""))))

Happy to help and thanks for the feedback