See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples):
(00:09) Deliver an OR Criteria Logical Value.
(02:15) 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).
(04:51) 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.