Excel sheet: https://imgur.com/7UwGWL0 1. How do i find how many stores achieved a Tier 4...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Excel sheet:
https://imgur.com/7UwGWL0
1. How do i find how many stores achieved a Tier 4 performance based on their January revenue?
2. Tier 5 perfomance based on February revenue?
3. How many stores achieved a Tier 3 or better performance based on their October revenue?
4. Assume we want to look up the revenue for March (cell AH11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AH11?
5.Assume we want to look up the number of employees (cell AI11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AI11?
6. Assume we want to look up a stores phone number (cell AJ11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AJ11?
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
