You are to create formulas that return the profit made from selling a greeting card. Current information

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 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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: