The Complete Formula That Corresponds to the Flowchart in the Accompanying

question 147

Multiple Choice

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

• A) =IF([Pay Grade]=2,2500,IF([Pay Grade]=1,5000,7500))
• B) =AND([Pay Grade]=2,2500,AND([Pay Grade]=1,5000,7500))
• C) =IF([Pay Grade]=1,2500,IF([Pay Grade]=2,5000,7500))
• D) =AND([Pay Grade]=1,2500,AND([Pay Grade]=2,5000,7500))

---

Definitions:

Diamond/Water Paradox

A paradox highlighting the contradiction where water, essential for survival, is inexpensive, while diamonds, with little intrinsic utility, are expensive.

Marginal Value

The additional value or benefit derived from consuming or producing one more unit of a good or service.

Total Utility

The total satisfaction received from consuming a certain amount of goods or services.

Marginal Utility

The incremental utility or happiness a consumer derives from acquiring and using an additional unit of a good or service.