Validation enables you to restrict the values that a User is allowed to
enter into a cell - you might have a formula which expects integer
values, for example, so you don't want to allow any fractional values.
Or, you might calculate the square root of a number - obviously, you do
not want negative numbers to be entered. You can also restrict input to
only certain values, by setting up a list in the sheet and only
allowing choices to be made from that list (via a pull-down).
To apply validation, select the cell(s) you want this to apply to and
Data | Validation - the dialogue box allows you to specify the
restrictions and also on other tabs you can specify an optional message
which you might want to display when the cell is selected (e.g. "Please
enter positive integer") as well as the error message to display and
the action to be taken when the data is not valid.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
