Dueling Excel 118

DESCRIPTION

Formula To Calculate Commissions for Four Scenarios
See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for the day, both may not be at work, one maybe be there while the other is not, and the other is but the one is not… See Mr Excel’s elegant formula, while excelisfun gets stuck in a “Two Way Lookup Conceptual rut”. See Mr Excel use the IF and the SUM and COUNTIF to create a brilliant formula.

WORKBOOKS