Question: You are to create formulas that return the profit made from selling a greeting card. Current information is given in cells B1:B7 of the file

You are to create formulas that return the profit made from selling a greeting card. Current information is given in cells B1:B7 of the file named Problem37data.xlsx. We ordered cards at a cost of $3.50 per card. Cards sold at full price are sold for $6. Full-price demand is entered in cell B7. The first 40 leftover cards are sold for $2. Remaining leftover cards are sold for $0.50. Write formulas that always return the correct profit for any set of nonnegative inputs.

Step by Step Solution

3.43 Rating (143 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create formulas that return the profit made from selling a greeting card based on the given infor... View full answer

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 Microsoft Excel Data Analysis 7th Questions!