Data validation whole percentage only

=TRUNC(A1*100)=(A1*100)
To allow only whole number percentages like 5%, 10% and not 5.5%, 10.25%, etc. you can use data validation with a custom formula based on the TRUNC function. In the example shown, the data validation applied to B5:B9 is:
=TRUNC(C5*100)=(C5*100)
The Excel TRUNC function does no rounding, it just returns a truncated number. It has an optional second argument (num_digits) to specify precision. When num_digits is not provided, it defaults to zero. In this formula for data validation to allow we use TRUNC get the non-decimal part of a percentage, after we multiply the percentage by 100.
For example, if a user inputs 15%:
If a user enters 15.5%, the formula evaluates like this
This formula doesn't validate anything else, for example that percentages are less than 100%. Additional conditions can be added with the AND function.
Notes: Data validation rules are triggered when a user adds or changes a cell value. Cell references in data validation formulas are relative to the upper left cell in the range selected when the validation rule is defined, in this case B5.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.