IF formula but ignoring conditions before

[maywal]

I have the formula below:

=IF(H5="Yes","Booked",IF(I5="Yes","T&C Sent",IF(J5="Yes","T&C Accepted",IF(M5="Yes","Invoice sent",IF(N5="Yes","Paid",IF(P5>0,"Typing",IF(S5="Yes","completed","Take action")))))))

I am using it to automatically show me which stage each job is at without having to go through the whole sheet. However, this formula only recognises the first condition even if the one after is true. I want it to look at the first condition and decide if it is true, then if this one plus the next one is true then "value" and so on.

How do I do this?

 

[Special-K99]

Since each column is a progressive stage of the job just reverse the order of the IFs, so IF(S5="Yes" is first, then comes IF(P5>0, etc until your last condition is IF(H5="Yes"...
That way you dont need to worry about previous conditions.

You're basically placing your IFs in order of importance, so Job Completion first and Booked last.