JY CHEN - Ask Anything, Learn Everything. Logo

In English / Middle School | 2025-07-07

What will happen if you apply data validation for "whole numbers between 1 and 100" and then try to enter 150 in that cell?

Asked by crazygirl2471

Answer (2)

Applying data validation for 'whole numbers between 1 and 100' restricts input to that range. If you enter 150, an error message will appear, preventing the input or alerting you that it is invalid. You must enter a valid number between 1 and 100 to proceed.
;

Answered by Anonymous | 2025-07-08

Answered by kumariunnati68 | 2025-07-17