If the cell value is less than or equal to 0, the rate is 10.00.
If the cell value is greater than 0 and less than or equal to the maximum rate (1,000), the rate is the cell value.
Otherwise, the rate is 10.00