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