One way:

Select A1. Use the inputboxes and dropdowns to set validation to

Allow: Whole number
Data: greater than
Minimum: 0
Enter you error alert.

Select A2. Set validation to
Allow: Custom
Formula: =AND(A2<=2500, A1*A2<=5000)
Enter your error alert.



In article ,
Rick wrote:

Problem:
I want validation on cell A2.
1) cell A1 must have a number 0 (in other words a whole number) and
2) A2's input must not exceed 2500 and
3) A3's calculation must not exceed 2500 (A#'s calculation is =A1*A2)