IF AND Formula help

[herpasymplex10]

I think this is possible, but i could be wrong.
I've got a formula

=IF(AND(F2="F",D2="PAP"),L2,"")

What i'd like is for the formula to look at just the last letter of the three letter code in D2

 

[Jonmo1]

=IF(AND(F2="F",RIGHT(D2,1)="P"),L2,"")


Hope that helps..

 

[MrKowz]

Try this out:

=IF(AND(F2="F",right(D2,1)="P"),L2,"")

Basically, this will say if the value in F2 = "F" and the last letter in D2 = P, then it will return the value in L2... otherwise it will remain blank.

Jonmo1 beat me to it!

 

[njimack]

Deleted

 

[herpasymplex10]

thanks for such quick replies
unfortunately i jumped the gun on my post

I need it to look at the last two letters from D2
if they are "AP" then return the value of L2

I appreciate the help
i'm sick and my mind is not working today

would it be this?

right(D2,2)="AP"

 

[MrKowz]

=IF(AND(F2="F",right(D2,2)="AP"),L2,"")

 

[herpasymplex10]

again. i spoke to soon
i'm having trouble adding an OR statement to the formula
F2 could be either "F" or "M"
for the statement to be true
help?

 

[MrKowz]

=IF(AND(OR(F2="F",F2="M"),right(D2,2)="AP"),L2,"")

 

[herpasymplex10]

=IF(AND(OR(F2="F",F2="M"),right(D2,2)="AP"),L2,"")

I really appreciate the help.