![]() Why does a wildcard IF statement fail? From all appearances, Excel doesn't recognize wildcards used with an equal sign or other logical operators. The formula returns "No" for all the cells, even those that contain "A": It seems like including wildcard text in the logical test would be an easy solution:īut regrettably it does not work. If found - display "Yes" in column B, if not - display "No". In the sample table below, supposing you want to check whether the IDs in the first column contain the letter "A". Why Excel IF function with wildcard not working
0 Comments
Leave a Reply. |