The standard IF function itself in Excel cannot perform case-insensitive text comparisons. However, you can achieve case-insensitive comparisons within an IF statement by combining the IF function with other functions that convert text to uppercase or lowercase.

Here are two common approaches:

1. Using the LOWER Function:

This method converts both the text you're checking and the comparison text to lowercase before performing the comparison in the IF statement.

```excel
=IF(LOWER(A1) = LOWER("apple"), "Match Found", "No Match")
```

In this example, cell A1 is converted to lowercase using LOWER(A1) and compared to the lowercase value "apple" within the IF statement. Regardless of the case of the text in A1 (APPLE, Apple, apple), the comparison will be case-insensitive.

2. Using UPPER Function:

Similar to the previous approach, you can convert both texts to uppercase for case-insensitive comparison.

```excel
=IF(UPPER(A1) = UPPER("APPLE"), "Match Found", "No Match")
```

Here, UPPER(A1) converts the text in A1 to uppercase and compares it to the uppercase value "APPLE".

Both methods achieve the same result – a case-insensitive text comparison within the IF statement. The choice between using UPPER or LOWER depends on your preference and how your data is typically formatted.