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...
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 ...
Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007
Tutorial: In Microsoft Excel you reference columns as letters by default - A1, B3, C5, etc. But you ...

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.