Logic test fails?

Topic

New Reply

A1 contains something like
DEPOSITPOINT 501373
A2 contains the formula
=A1=”*501???”
It returns the value FALSE
I think that A1 does contain the specified string, so the result should be TRUE.
What’s wrong?
JRR

Reply | Quote

Replies

It fails since you are testing whether A1 is literally the string “*501???” which it is not.

You can use (depending on what you want:

=ISNUMBER(SEARCH(“501”, A1))
to see if it contains ANY “501” though could be at end of string or even:

=COUNTIF(A1,”=*501???”)>0

Steve

Reply | Quote

You’re a star, Steve.
If you do a custom filter, the criteria handle wildcards: but not, it seems, the formula.
Not in the same way, anyway.
Thanks again
JRR

Reply | Quote