Return True or False statement if last 5 characters match or not

**Eduards** · 02-20-2019, 05:22 AM

Hi,

I have multiple codes such as:
0001101OL
0002400OL
0003396OL

Id like the following formula:
If last 5 characters of the codes above is: 400OL or 396OL then say 'TRUE' if not then false

**SjonR** · 02-20-2019, 05:28 AM

try this:

PHP Code:


=OR(RIGHT(A1,5)="400OL",RIGHT(A1,5)="396OL")

**Eduards** · 02-20-2019, 06:15 AM

Thank you all!

Return True or False statement if last 5 characters match or not

LinkBack

Thread Tools

Rate This Thread

Display

Return True or False statement if last 5 characters match or not

Re: Return True or False statement if last 5 characters match or not

Re: Return True or False statement if last 5 characters match or not

Thread Information

Users Browsing this Thread

Similar Threads

How to write one single line of VBA code to return TRUE/FALSE for And/Or statement?

If(And) Statement for sorting time stamp to return true or false value

Move to next cell if the statement is false return value if true. -- PROBLEM

[SOLVED] Multiple ifs to return more than true or false statement

How to return a value instead of TRUE/FALSE with IF,OR,AND statement

[SOLVED] Text String search from a web query to return a True/False Statement

Match and return a true false value

Bookmarks

Bookmarks

Posting Permissions