Excel Forum

Excel Magic Trick 100: Instead of Long IF, Use MEDAIN function Commission W Hurdle Calculation

Formula from Mr Excel Challenge at Mr Excel web site. You will not believe your eyes: See how to replace a complicated IF formula with the MEDIAN function, or a MIN MAX formula. See 3 amazing examples.

When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function formula, it may be easier to use the MEDAIN function in your formula.

See a Payroll example, a Sales Commission Example and an extra-credit homework example.

Got a Question? Ask it Here in the Forum.