Here's how to check if a cell falls within a specific range using the IF function in Excel:

Formula:

```excel
=IF(AND(A1>=LowerBound, A1<=UpperBound),"In Range","Out of Range")
```

Explanation:

- A1: Replace this with the cell reference you want to check (the cell containing the value to be evaluated).
- LowerBound: Replace this with the lower limit of your desired range (the smallest acceptable value).
- UpperBound: Replace this with the upper limit of your desired range (the largest acceptable value).

How it Works:

1. The `AND` function checks two conditions simultaneously:
- A1>=LowerBound: This part ensures the value in cell A1 is greater than or equal to the lower bound.
- A1<=UpperBound: This part ensures the value in cell A1 is less than or equal to the upper bound.
2. If both conditions in the `AND` function are true, the IF function returns the text "In Range."
3. If either condition is false, the IF function returns the text "Out of Range."

Example:

Let's say you want to check if the value in cell B2 falls between 50 and 100 (inclusive). You would enter the following formula in another cell (e.g., C2):

```excel
=IF(AND(B2>=50, B2<=100),"In Range","Out of Range")
```

- If the value in B2 is between 50 and 100, cell C2 will display "In Range."
- If the value in B2 is less than 50 or greater than 100, cell C2 will display "Out of Range."

Customization:

- You can modify the text returned by the IF function to display any message you like based on the outcome (e.g., "Valid," "Invalid").
- You can adjust the cell references and range limits to suit your specific needs.