Results 1 to 3 of 3

Thread: Data Validation

  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can't dream up a logical reason for why one has to specify a minimum and Maximum in the (Excel 2000) settings tab when specifying a Whole Number.
    The "data" box insists on a relational operator, and the tab insists on a Minimum and Maximum value.

    I can understand requiring a Min/Max value once one has requested a relational operator,
    but for the life of me I can't see why one couldn't allow a data validation rule to state, simply "must be a whole number".

    That is, I suspect this is another poorly-thought out design feature - the programming team having decided that one HAS to have a relational operator.
    Attached Images Attached Images
    • File Type: jpg 1.JPG (22.9 KB, 1 views)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    They could have added an option "Any" to the dropdown list, but they haven't...

    I think that in most real-life situations there will be limits to the numbers the user should be able to enter.
    You can always specify -999999999999999 as minimum and 999999999999999 as maximum to allow the entire range of whole numbers that Excel can handle (Excel stores numbers with a precision of 15 digits).

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='chrisgreaves' post='783053' date='04-Jul-2009 20:19']I can't dream up a logical reason for why one has to specify a minimum and Maximum in the (Excel 2000) settings tab when specifying a Whole Number.
    The "data" box insists on a relational operator, and the tab insists on a Minimum and Maximum value.

    I can understand requiring a Min/Max value once one has requested a relational operator,
    but for the life of me I can't see why one couldn't allow a data validation rule to state, simply "must be a whole number".

    That is, I suspect this is another poorly-thought out design feature - the programming team having decided that one HAS to have a relational operator.[/quote]
    Hi Chris

    Just for fun try the following Custom specification (assuming you are validating A1):
    =A1=INT(A1)
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •