Entered number must fall within range.

  • Thread starter Thread starter Les Ankersen
  • Start date Start date
L

Les Ankersen

Hello All,

I am looking for a way, only except a number in a cell within a range.
example: number entered must be between 40 and 60, if 38 is entered an error
shows, or something shows you that you need to re-enter a number.

Thanks for you help.

Les
 
Check out Data/Validation (see "About setting restrictions on cells and
displaying input and error messages" in XL Help).
 
Click on : Data/Validation

On the "Allow:" box, highlight/click on "Whole Number"

You will then be prompted for minimum and maximum values. Enter the
minimum/maximum values that suit your application and then click OK.
 
Hi Les........

Select the cell you want, then, Data > Validation > Whole number (or
Decimal) > and then set your Minimum and Maximum values in the windows
below.

Vaya con Dios,
Chuck, CABGx3
 
Les Ankersen said:
Hello All,

I am looking for a way, only except a number in a cell within a range.
example: number entered must be between 40 and 60, if 38 is entered an error
shows, or something shows you that you need to re-enter a number.

Thanks for you help.

Les
Click to expand...

It sounds like what you are looking for is under:
DATA | VALIDATION - then select either decimal or whole number and
set your between ranges.

Next, you can select the Tab titled "ERROR ALERT" and set a message to
display when an invalid number is entered.
 
Back
Top