If And statement not showing results I want

[JREYNA03]

my formula keeps showing me the result of "1" instead of the words I want "Send Letter

=IF(AND(G4="yes"),1,IF(AND(I4=@Cancelled),2,IF(AND(M4<TODAY()),"Send Letter")))

 

[RoryA]

Why are you using AND with only one argument? It serves no purpose.

Perhaps you could explain what you want the formula to do?

 

[ExceLoki]

currently your first and only has one condition it's checking, so if g4=yes then it will be 1
are you wanting if(and(g4=yes, i4=@cancelled, m4<today()),"send letter") ??

 

[JREYNA03]

Why are you using AND with only one argument? It serves no purpose.

Perhaps you could explain what you want the formula to do?

I am wanting the formula to show "Send Letter" if the below columns contain the below words

G4=YES
I4=CANCELLED
M4<TODAY

 

[JREYNA03]

currently your first and only has one condition it's checking, so if g4=yes then it will be 1
are you wanting if(and(g4=yes, i4=@cancelled, m4<today()),"send letter") ??

I have this but it gives me the "#Name?" error

 

[JREYNA03]

I updated but now it is showing "True", "False" instead of the words I need it to display

=@IF(AND(G4="yes"),AND(I4="Cancelled"),AND(M4<TODAY()),AND(P4="YES"),"Cancel Plates", "Do Not Cancel Plates")))

 

[JREYNA03]

I have this but it gives me the "#Name?" error

I updated but now it is showing "True", "False" instead of the words I need it to display

=@IF(AND(G4="yes"),AND(I4="Cancelled"),AND(M4<TODAY()),AND(P4="YES"),"Cancel Plates", "Do Not Cancel Plates")))

 

[Fluff]

How about

=IF(AND(G4="yes",I4="Cancelled",M4<TODAY(),P4="YES"),"Cancel Plates", "Do Not Cancel Plates")

 

[JREYNA03]

How about

=IF(AND(G4="yes",I4="Cancelled",M4<TODAY(),P4="YES"),"Cancel Plates", "Do Not Cancel Plates")

You are awesome!
Thank you. It worked!!

 

[Fluff]

Glad we could help & thanks for the feedback.