Try this:

=CEILING(MAX(A1-50,50)/350,1)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"DeMangello1" wrote in message
...
Generally, 1 day of travel time is allowed for each 350 miles of official
distance of ordered travel. If the excess is 51 miles or more after
dividing
the total number of miles by 350, one additional day of travel time is
allowed. When the total official distance is 400 miles or less, 1 day's
travel time is allowed.

So if the total travel time was 750 miles this would only be 2 days of
travel. 751 would be 3 days of travel....and so on