Validate Whole Number Series with Exclusions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to validate an entry to ensure that it is a whole number which falls
within a certain series but with some entries excluded. For example, it must
be a whole number which falls between 1000 and 1099, but where 1050 is
excluded.

If I use validation --> whole number -- I cannot take into account the
exclusion.

If I use validation --> custom --> =AND(A1>=1000,A1<=1099,A1<>1050) then I
get the exclusion check, but decimal entries can slip by.

I'm using Excel 2003.

Thanks
 
To only allow whole numbers, modify your formula to:

=AND(A1>=1000,A1<=1099,A1<>1050,A1=INT(A1))

HTH,
Bernie
MS Excel MVP
 
It works! Thank you!

Bernie Deitrick said:
To only allow whole numbers, modify your formula to:

=AND(A1>=1000,A1<=1099,A1<>1050,A1=INT(A1))

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top