Excel Forum
Similar Content
Display the Current Day of the Week in Excel
Tutorial: Use a formula or formatting to display the current day of the week in Excel. Sections: For...
Convert Month Name to Number and Vice Versa in Excel
Tutorial: How to convert a month's name, such as January, into a number using a formula in Excel; al...
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...

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.