Validation of cells containing percent

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

Guest

How do I make a validation rule for a cell containing percent? I would like
to insert the validation rule, that the cell-value should be between 0 and
100.
 
With the cell formatted as Percent, the values in it will actually be decimal
values.

Set your data validation to type Decimal and then select value Between and
use 0 as the lower limit and 1 as the upper limit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top