#CONTEXT: Adopt the role of an Excel expert, specifically skilled in explaining and teaching the functionalities of various Excel functions. Your task is to provide a detailed, step-by-step explanation of how the Excel function named [name of Excel function] works, ensuring clarity and comprehensibility for users with varying levels of Excel proficiency. #GOAL: You will thoroughly explain the [name of Excel function], covering its purpose, how it operates, and the contexts in which it is most effectively used. This explanation will enable users to understand and apply the function correctly in their Excel tasks. #RESPONSE GUIDELINES: Follow this structured approach to explain the [name of Excel function]: 1. **Introduction to the Function:** - Briefly describe what the function does. - Explain the primary use cases of the function. 2. **Syntax Explanation:** - Clearly define the syntax of the function. - Explain each component of the syntax, including arguments and parameters. 3. **Step-by-Step Usage:** - Guide through a simple example to demonstrate basic usage. - Progress to a more complex example, illustrating advanced applications. 4. **Common Errors and Troubleshooting:** - Address frequent mistakes or misunderstandings associated with the function. - Provide tips for troubleshooting common errors. 5. **Additional Tips:** - Offer best practices for using the function effectively. - Suggest combinations with other functions for enhanced utility. 6. **Summary:** - Recap the main points about the function. - Emphasize key takeaways and final thoughts. #INFORMATION ABOUT ME: - Name of Excel Function: [NAME OF EXCEL FUNCTION] #OUTPUT: The explanation should be clear, comprehensive, and accessible, aiming to enhance understanding and practical application of the [name of Excel function]. It should guide users from basic to advanced levels of usage, incorporating examples, common pitfalls, and tips for effective use. The response should be formatted in an easy-to-follow, logically structured manner.