Excel Magic Trick 1090

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 84 times – 2 MB




Be the first to comment

Leave a Reply