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.

 

[Rick Rothstein]

Ok how about

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

I know the logic is "backward", but you could also write it this way...

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