Multiple outcome if and statement

[retroboy17]

Alright, looking for some help on this one:

I have the following columns: Status (column C), New Status (Column D) and Date Sent (column M)
Status column (C) contains multiple stages of progress status (Being Reviewed, Filed Not, etc)
New Status (D) column is blank (this is where I will enter the formula)
Date Sent (M) has mostly blank cells but some with dates in them

I would like a formula in column D (New Status) which evaluates C (Status).
If C = "Filed Not" AND M is blank, then output "Filed Not - Not Sent"
If C = "Filed Not" AND M has a date in it, then output "Filed Not - Sent"
If C <>"Filed Not" then output whatever data exists in C

I hope this makes sense. I can get each of these to work individually, however, I can't, for the life of me, get them to work into one equation.
I would appreciate, very much, any help I can get on this one...

Thanks, in advance!

[AliGW]

=if(and(c1="Filed Not",isblank(M1)),"Filed Not - Not Sent",if(and(c1="Filed Not", m1<>""),"Filed Not - Sent", c1))

[judgeh59]

@Ali-----good job on the ISBLANK---lot of folks don't use that....

[retroboy17]

You are amazing!
Works perfectly.
Thanks!

[AliGW]

You are amazing!
Works perfectly.
Thanks!

Which one?

[judgeh59]

just another look

=IF(AND(C1="Filed Not",ISBLANK(M1)),"Filed Not - Not Sent", IF(AND(C1="Filed Not",NOT(ISBLANK(M1))),"Filed Not - Sent", IF(C1<> "Filed Not", C1,"")))

[popipipo]

=IF(C1="Filed Not","Filed Not - Not Sent",C1)

[AliGW]

=IF(C1="Filed Not","Filed Not - Not Sent",C1)

This doesn't handle the "File Not - Sent" condition, does it?