Excel Magic Trick 1157

Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula


See how to use MEDAIN Function to calculate Mileage Costs at $0.40 Under or Equal to 10,000 Miles and $0.25 Over 10,000 Miles, where the key concept is that there is a hurdle and when the running total gets past the hurdle, the cost per miles is reduced.

Be the first to comment

Leave a Reply