Control Sheet

[Guest]

I need to check that the values entered in a seperate sheet are entered
correctly within a certain range.

If the entry is out of range, the user must get an error message that the
entry is invalid.

For instance:
=IF(AND(A1>=1;A1<=500);allow entry;disallow and prompt user because of
invalid entry)

What do I do?

Best regards,
Sonni

 

[Guest]

Select A1
<Data>
<Validation>
In the "Allow" drop down choose "Decimal" (or "Whole Number" if you just
want integers)
Enter 1 for Minimum, 500 for Maximum

 

[Guest]

Hi!

The thing is that I want to maintain allowed values in one sheet, so
Validation won't work.

Any other ideas?

BR,
Sonni