validation

  • Thread starter Thread starter Petrus
  • Start date Start date
P

Petrus

I have a sheet in which i want to validate the values that are filled
in: possible must be the numbers from 0 to 100 and the value "absent".

How do i do this?
 
One way ..

Assume inputs would be made in col A, A1 down

Select col A

Click Data > Validation
Select Custom under "Allow"
Put as the "Formula:"
=OR(AND(A1>=0,A1<=100),A1="absent")
Click OK

Test it out ..
 
Max said:
One way ..

Assume inputs would be made in col A, A1 down

Select col A

Click Data > Validation
Select Custom under "Allow"
Put as the "Formula:"
=OR(AND(A1>=0,A1<=100),A1="absent")
Click OK

Test it out ..
Click to expand...
Thanks a lot, it works . I had to replace the , by a ;
 
Back
Top