excel, add multiple conditions to if statement

Question

I am trying to have "P9" change based on the following conditions. Can I do this with one formula or would a macro be better?

If M9=S9 "COMPLETE"
If S9=0 "NOT COMPLETE"

If S9 '<' M9 Then add following text (S9 & "-COMPLETE")⁽¹⁾
If T9 '<' M9 Then add following text (T9 & "-NOT COMPLETE")⁽¹⁾

Would the =SUMIFS formula work for this?

---

⁽¹⁾ I would like these two to be formatted one on top of the other (see R9 as an example)

Answer 1

Yes it can be done in one formula, make sure your Wrap Text is on for the cell:

=IF(M9=S9,"COMPLETE",IF(S9 = 0, "NOT COMPLETE",S9 & "-COMPLETE" & CHAR(10) & T9 & "-NOT COMPLETE"))