mardi 21 février 2017

MS Excel - If statement (multiple arguments)

Having trouble with this one, not sure what I'm missing. Inserting this formula in cell O2. The three cells to the right contain one of three status', "Complete","In Process",or "Incomplete".

If all three cells dispay "Complete" then I want O2 to Display "Complete", if any of the cells display "Complete" but others are "In Process" or "Incomplete" I want it to diplay "In Process", but if all cells are "Incomplete" I want it to display "Incomplete:

Here's my current formula:

=If(P2="Complete"AND(Q2="Complete",R2="Complete"),"Complete",IF(P2="Complete"OR(Q2="Complete",R2="Complete")AND(P2="In Process"OR(Q2="In Process",R2="In Process")),"In Process",IF(P2="Incomplete"OR(Q2="Incomplete",R2="Incomplete")AND(P2="In Process"OR(Q2="In Process",R2="In Process")),"In Process", "Incomplete")))

Feel like I'm missing an argument or have too many! Thank you greatly for your help!

Aucun commentaire:

Enregistrer un commentaire