Question
I have a large excel spreadsheet with store sales data on it. Looking for what formula and how to format said formula to answer the
I have a large excel spreadsheet with store sales data on it. Looking for what formula and how to format said formula to answer the following questions.
1) Best Sellers are defined by Quantity Sold greater than 300 and Profit greater than $10.00. Fill in the "Best Seller?" column with Yes/No to identify these items.
2) Stale items are defined by Quanity Sold as 65 or fewer items OR profit less than $2.00. Fill in the "Stale Item?" column with Yes/No to identify these items.
Please use cell refrences from within the spreadsheet pictured below in your formula for easier understanding. Thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started