Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagCalculation 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?