If cell contains a specific character, then TRUE, if not, then FALSE

[megera716]

This seems like an exceedingly simple problem but I'm having trouble applying my Google results to my situation.

I have a table full of sales data, with Invoice Numbers in Column C. In a formula I've got way over in Column X, I just want to say if Column C contains "A", "B", "C" or "D" is true, run one formula and if it it's false, run a different one. I've already got those formulas and don't need help with that, just how to write the logical test.

A lot of what I found on Google was checking a range for a value in a different cell but I don't have it set up that way and don't really want to.

 

[Eric W]

Try:

=IF(OR(C13={"A","B","C","D"}),TRUE,FALSE)

Put formula1 where TRUE is, and the other where FALSE is. If you have the letter contained within a larger string like "123-A", we can use a SEARCH option.

Also, this is an Excel formula, I don't know if it will work on Google.

 

[Fluff]

How about

=IF(OR(C2={"a","b","c","d"}),formula1,formula2)

Beaten 2it again.

 

[megera716]

Thank you @Eric W ! I notice the curly brackets in the middle there, is this an array formula that I need to do Ctrl-Shift-Enter? Also, I just meant my Google results had not been helpful but I am using Excel, not Google Sheets or anything.

This is my bad for not being clear in my OP, but I need to know if the cell contains those letters, but it will definitely have other data in it too. A few example invoice numbers:
17237
17192A
17238
17241B
etc.

The formula as written would only return something if the A, B, C or D is the only thing in that cell, yes?

 

[Fluff]

Do you just want to check if the last character is not a number?

 

[megera716]

Do you just want to check if the last character is not a number?

yes that should work!

 

[Fluff]

Ok how about

=IF(ISERROR(RIGHT(C2)+0),formula1,formula2)

 

[Dave Patton]

T202009c.xlsm
	B	C
2	17237	FALSE
3	17192A	TRUE
4	17238	FALSE
5	17241B	TRUE
6	5Z	FALSE
7
3b

Cell Formulas
Range	Formula
C2:C6	C2	=OR(RIGHT(B2)={"a","b","c","d"})

 

[megera716]

T202009c.xlsm
	B	C
2	17237	FALSE
3	17192A	TRUE
4	17238	FALSE
5	17241B	TRUE
6	5Z	FALSE
7
3b

Cell Formulas
Range	Formula
C2:C6	C2	=OR(RIGHT(B2)={"a","b","c","d"})

Dave, this was perfect! @Fluff, yours also returned the desired result , for the most part. However, sometimes we have invoice numbers that end with R (for Revised, if we needed to change it after the initial send) and the formula captured those too, which I don't want it to do in this case.

Thank you both!

 

[Fluff]

That's why I asked "Do you just want to check if the last character is not a number?"

Glad your sorted & thanks for the feedback.