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

1. ## 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. ## 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.

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

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

4. ## 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.

5. ## 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.

6. ## 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
•