Calculation based on condition

Copper Contributor

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?

 Screenshot 2024-03-11 070929.png


1 Reply

@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...