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

Topic

New Reply

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(I650,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 i650. Any help would be great. Thanks

Reply | Quote

Replies

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.

Reply | Quote

Other pic that shows how to format the target cell…

Reply | Quote

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…

=if(iserror(I65/H69),"",if(I650,I65/H69,""))

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote