Excel Magic Trick 1090: MEDIAN Function 3 Amazing Uses: OR Criteria, Payroll, Commissions

See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples):
1. (00:09 min) Deliver an OR Criteria Logical Value. (Cool trick from Xlarium from YouTube.)
2. (02:15 min) Payroll Tax calculation where there is a hurdle, past which no tax is paid. (Ceiling Amount). By using MEDIAN we avoid complicated IF function for payroll calculation. Use MEDIAN to pick out middle value from three values: 0, full pay check amount or partial paycheck amount (Ceiling for Tax minus Begin Cumulative Amount).
3. (04:51 min) Commission calculation where there is a hurdle Amount, past which you earn a higher commission rate. Avoid more complicated formula by using MEDIAN to pick out middle value from three values: 0, Running Total minus Hurdle for Higher Commission Rate.

Cool formula tricks with MEDIAN function

[excelisfun]

Excel Magic Trick 1090: MEDIAN Function 3 Amazing Uses: OR Criteria, Payroll, Commissions

Wild uses of MEDIAN to create shorter formulas for payroll and commissions!!!!

[ExcelxlNl]

Wow Mike as usual a great great video. And what a magnificent and creative use of the median function. Thanks

[maneshzaveri]

Excellent one - really makes life easy