Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula

See how to us 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.

Other Related Videos:
Mr Excel Excel Challenge back in 2007
Excel Magic Trick 100: Instead of Long IF, Use MEDAIN function Commission W Hurdle Calculation
Excel Magic Trick 1090: MEDIAN Function 3 Amazing Uses: OR Criteria, Payroll, Commissions

[excelisfun]

Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula
See how to us 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.

[alaeddin]

haha that's INSANE  that idea of using the median !
thanxs 4 sharing

[jakael]

That's some snazzy stuff there... great video

[TonyAllenAT]

Love it!  Just say No to "IF/THENs" is what I always say.  :)

[BillSzysz]

Awesome !!! Cool !!! Fantastic !!!
Thanks :-))

[ivanperez]

Im in a bit of a pickle... i have data sets that are in range of 60-80k of rows and 50 colums. Inwhich the majority I dont use. My line of work is pharmacy claims. heres my scenario:
colum A= patient name
colum B= drug name
colum C= paid claim ( in which there are duplicates of a negative and positive)
How do i create a formula to pair those to void them out of my report.
I have painly  been sorting them by Asorting/Desending order and manually picking them < highlighting them, and finally deleting them..
Please can anyone help me cut this 3 day task down??