Actually, wildcards (* and ?) cannot be directly used with the IF function for text comparisons in Excel. The IF function itself doesn't support wildcards for pattern matching.

However, there are alternative ways to achieve partial text matching within IF statements:

1. Using the SEARCH or FIND functions:
These functions can identify the position of a substring within a text string. You can then combine them with logical operators (AND, OR) within the IF statement to achieve the desired logic.

2. Concatenating Text with Wildcards:
You can build a text string that incorporates wildcards and use it for comparison within the IF statement. For example, to check if a cell contains "text" anywhere within its content, you could use `IF(A1="*text*", TRUE, FALSE)`.

3. VLOOKUP or MATCH with Wildcards:
In some scenarios, using VLOOKUP or MATCH with wildcards can be a more efficient approach for complex partial text matching.

Remember, the best method depends on your specific needs and data structure. Consider factors like data size and desired outcome when choosing the most suitable approach.