Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to format cell to input only a range of number (2000/2003)

    Hello,

    I got two questions that I think are easy, but can't figure out. The first one. I have a cell where a staff has an option of selecting a range from 0-10% number to input. This number doesn't have to be a whole number. It could be 9.99%. I tried to use the validation, but you have to use whole numbers only or decimals which defeats the purpose for the range.
    The second question, I have a what if statement in a cell, the statement is =IF(I65<>0,I65/H69,""), I want to make it so if the division in I65/H69 an error will appear and I still want to show nothing if i65<>0. Any help would be great. Thanks

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to format cell to input only a range of number (2000/2003)

    Enter 0% and 10% into two separate cells as shown below. Set your data validation as indicated. Then you can format the target cell using "percent" and set the decimal places to two and shown in the next post. Now only percentages between 0% and 10% will be allowed.
    - Ricky

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to format cell to input only a range of number (2000/2003)

    Other pic that shows how to format the target cell...
    - Ricky

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to format cell to input only a range of number (2000/2003)

    Not sure i understand the second question in your post but if you're trying to prevent an error "DIV0" where the division results in an error, you could do this...

    <pre>=if(iserror(I65/H69),"",if(I65<>0,I65/H69,""))</pre>


    This will check first to see if the division results in an error and if so will return a blank (""). If the division does not result in an error, then your original If statement will proceed.
    - Ricky

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to format cell to input only a range of number (2000/2003)

    On your first question, you can set up validation as shown below in the screen shot below.

    I am afraid I don't understand your second question.
    Legare Coleman

  6. #6
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to format cell to input only a range of number (2000/2003)

    Thank you all for the information. I got what I needed.

Posting Permissions

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