Calculation based on condition

[wmf_wmf_07]

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?

 

[#2]

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