issues with IF function

Question

Hello!

I am using the IF function to create information in a cell by pulling the last two characters from a different cell. I have the formula, but I can't figure out what the error is. When I enter it as is below it errors out.

=LET(s, RIGHT(E1, 2), IF(s={"Ch","CR","MC","PA","Wi","Ec"}), "REVENUE ADJUSTMENT", IF(OR(s={"In","Se"}), "NON CASH RECEIPT"))))

https://learn-attachment.microsoft.com/api/attachments/71edaf6f-0b84-4cdd-b791-2ffd98d4ced8?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/a501f373-23c6-4f6f-b3bc-432df8ca163e?platform=QnA" rel="ugc nofollow">https://learn-attachment.microsoft.com/api/attachments/a501f373-23c6-4f6f-b3bc-432df8ca163e?platform=QnA

Answer 1

One way, out of many:

=LET(s, RIGHT(E1, 2), IF(ISNUMBER(SEARCH(s,"ChCRMCPAWiEc")), "REVENUE ADJUSTMENT", IF(OR(s="In",s="Se"), "NON CASH RECEIPT","NA")))

or maybe just

=IF(ISNUMBER(SEARCH(RIGHT(E1, 2),"ChCRMCPAWiEc")), "REVENUE ADJUSTMENT", "NON CASH RECEIPT")

or

=IF(OR(RIGHT(E1, 2)="In",RIGHT(E1, 2)="Se"), "NON CASH RECEIPT", "REVENUE ADJUSTMENT")