Question

b2 =if(a2>20,5,10)

inventory on hand: 10
selling price per unit: $10.00
inventory value: $100.00

$50.00
$100.00
$150.00
$1,000.00

Explanation:

Evaluate the logical condition

Using the Excel IF Function knowledge point

$$ \text{Condition: } A2 > 20 $$

$$ \text{Since } A2 = 10, \quad 10 > 20 \text{ is False.} $$

Determine the formula output

Using the Excel IF Function and Spreadsheet Formulas knowledge points

$$ \text{Formula: } =IF(A2>20, 5, 10) $$

$$ \text{Since the condition is False, the formula returns the value\_if\_false: } 10 $$

Calculate the resulting inventory value

Using the Spreadsheet Formulas knowledge point

$$ \text{New Selling Price per Unit (B2)} = \$10.00 $$

$$ \text{Inventory Value (C2)} = A2 \times B2 = 10 \times \$10.00 = \$100.00 $$

Answer:

• $50.00
• $100.00 (Correct answer)
• $150.00
• $1,000.00