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

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

--
Regards,
Dave


"Cedrun" wrote:

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

Hi!

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

Any other ideas?

BR,
Sonni

"David Billigmeier" wrote:

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

--
Regards,
Dave


"Cedrun" wrote:

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