Which formula would restrict input to whole numbers between 0 and 100?

Which formula would restrict input to whole numbers between 0 and 100?

• A. =AND(A1>=0, A1<=100)
• B. =A1>0
• C. =ISNUMBER(A1)
• D. =OR(A1<0, A1>100)

Answer: (A)

Using a logical AND to enforce that a value falls within a specified range is the idea here. The formula checks that A1 is at least 0 and at most 100, and because both conditions must be true, the input is valid only when it lies between 0 and 100 inclusive. That directly implements the requirement of staying within that range. If you truly need whole numbers, you’d also add a check that the value is an integer, such as INT(A1)=A1, so the result would require both the range and the integer property. The other options don’t achieve the same effect. One only ensures the value is greater than 0, missing the upper bound. Another only tests that the input is a number, not its range. The last tests for values outside the range, which would mark valid inputs as invalid.

Using a logical AND to enforce that a value falls within a specified range is the idea here. The formula checks that A1 is at least 0 and at most 100, and because both conditions must be true, the input is valid only when it lies between 0 and 100 inclusive. That directly implements the requirement of staying within that range. If you truly need whole numbers, you’d also add a check that the value is an integer, such as INT(A1)=A1, so the result would require both the range and the integer property.

The other options don’t achieve the same effect. One only ensures the value is greater than 0, missing the upper bound. Another only tests that the input is a number, not its range. The last tests for values outside the range, which would mark valid inputs as invalid.