Skip to content

Opening book details…

Can I read IF Formula for Pass/Fail Criteria on EtoBox?

IF Formula for Pass/Fail Criteria by S Prasana Varshan 1830591 is a document available to read on EtoBox.

What is IF Formula for Pass/Fail Criteria about?

Here are the steps to solve this problem: 1. Use the SUM function to find the total sales for each agent across the 4 quarters. 2. Use the MAX function to find the agent with the highest total sales. 3. Use the SMALL function to find the totals for the bottom 3 agents. So the results would be: Top 1: James Beck with total sales of ₹31,000 Bottom 3: Thomas McAllister with total sales of ₹1,000 Patricia Cole Blair with total sales of ₹10,460 Sara O

Author
S Prasana Varshan 1830591
Language
EN