Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 12

IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions

Questions answered in this chapter:

• If I order up to 500 units of a product, I pay $3 per unit. If I order between 501 and 1,200 units, I pay $2.70 per unit. If I order between 1,201 and 2,000 units, I pay $2.30 per unit. If I order more than 2,000 units, I pay $2 per unit. How can I write a formula that expresses the purchase cost as a function of the number of units purchased?

• I just purchased 100 shares of stock at a cost of $55 per share. To hedge the risk that the stock might decline in value, I purchased 60 six-month European put options. Each option has an exercise price of $45 and costs $5. How can I develop a worksheet that indicates the six-month percentage return on ...