Forum Discussion
Calculation based on condition
I need to calculate each employee's bonus if they achieve sales > 90% in all categories (Bonus = 'Rate' x ' % 'for each category). If even one category is less than 90 % then the bonus should be 0. How can I formulate this?
wmf_wmf_07 Based on the sample data shown, one possible formula for the Bonus column would be:
=IF(MINIFS([Sales %], [ID], [@ID])<0.9, 0, [@Rate]*[@[%]])See attached workbook, if needed...
