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!

I have a large excel spreadsheet with store sales data on it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!