Explanation

Use Whole Number when decimal values are not allowed.

Example:

Employee Age: 18–60

Validation:

Allow → Whole Number
Data → between
Minimum → 18
Maximum → 60

Decimal Example

For Product Discount:

Allow → Decimal
Data → between
Minimum → 0
Maximum → 50

This allows discounts such as:

  • 5
  • 10.5
  • 25
  • 37.5

Practice

Create validation rules for:

Field

Allowed Values

Age

18–60

Quantity

1–100

Discount

0–50

Salary

10,000–200,000
PreviousNext