How to use IF formula for multiple conditions together

[Pancakey]

Hello, so I am trying to put two conditions together with an IF statement, how can I make it valid?

Column M = Cells with text
Column R = Paid or Unpaid status

I would like the statement to be able to search and say since Column M and Column R says this, then it will say Completed. If Column M and Column R does not match, or contain one of those text conditions, then it will say Incomplete.

=IF(AND(M4="*",R4="Paid"),“Completed”, “”)”
=IF((M4="*")+(R4="Paid"),“Completed”, “”)

 

[bebo021999]

May be:

=IF(AND(M4<>"",R4="Paid"),"Completed","")