Formula which calculates the number of authorized days based upon

D

DeMangello1

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
 
R

Ron Coderre

Try this:

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

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

Regards,

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

DeMangello1

This did exactly what I wanted.

Ron Coderre said:
Try this:

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

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
R

Ron Coderre

Great! I'm glad that helped.

Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

testing a string for either "Minutes" and/or hours and extracting the values 5
help with formula 1
Need your help please , complex issue 4
I need help with 6 worksheet functions! 11
Formula to place the same value in a specific number of cells 4
Converting total number of hours (>24 hours) into days 1
Sum and average number of days and hours 4
Summing rows based upon condition 2

Top