validation

[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?

 

[Max]

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 ..

 

[Petrus]

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 ..
--
Rgds
Max
xl 97

Thanks a lot, it works . I had to replace the , by a ;

 

[Max]

Thanks a lot, it works . I had to replace the , by a ;

Glad it worked, and you figured out how to adapt to suit <g>