How to Check if Value is in Range in Google Sheets

To check if a value is in a specific range in Google Sheets, you can use the IF and AND functions together. The IF function checks whether a condition is met and returns one value if the condition is met and another if it's not. The AND function checks if all conditions are met and returns TRUE or FALSE. Combining these two functions, you can create a formula that checks if a value is within a specific range.

Here's a step-by-step guide on how to check if a value is in range in Google Sheets:

1. Open your Google Sheets document.
2. Click on the cell where you want to display the result.
3. Type the following formula:

=IF(AND(A1>=B1, A1<=C1), "In Range", "Out of Range")

In this formula:

• A1 represents the cell containing the value you want to check.
• B1 represents the cell containing the lower limit of the range.
• C1 represents the cell containing the upper limit of the range.
• "In Range" is the text displayed if the value is within the range.
• "Out of Range" is the text displayed if the value is outside the range.

4. Press Enter to apply the formula.

Example

Here's an example to demonstrate how to use the formula:

1. In cell A1, enter the value you want to check. For example, let's assume you want to check if the value 50 is within the range of 30 to 100. Enter 50 in cell A1.
2. In cell B1, enter the lower limit of the range. In our example, this is 30.
3. In cell C1, enter the upper limit of the range. In our example, this is 100.
4. In cell D1, type the formula:

=IF(AND(A1>=B1, A1<=C1), "In Range", "Out of Range")

5. Press Enter to apply the formula.

If the value in A1 is within the specified range, cell D1 will display "In Range"; otherwise, it will display "Out of Range". In our example, cell D1 will display "In Range" since 50 is within the range of 30 to 100.